Tom Andrews on 02 Sep 2015 16:45:54
It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.
- Comments (50)
RE: Conditional Formatting throughout
This is pretty easy to conditional format text if your using IMPORT or SQL, this doesn't work on DIRECT connections.
First create additional NEW COLUMN in your table
The following query will populate the NEW COLUMN based on the test string you defined, in the example ive used planet names
StatusColour = If('table'[table.value]="mars",0) & if('table''[table.value]="sun",1) & if('table'[table.value]="earth",2)
You can then apply conditional formatting to your TEXT column either background colour or font colour or both (example below)
Based on Field = NEW COLUMN (SUM)
IF value is 0 then
IF value is 1 then
IF value is 2 then
shame about pie charts, hope that comes soon!
RE: Conditional Formatting throughout
I have a clustered column chart showing sales for this year vs. equivalent period last year.
I'l like to be able to highlight the current month this year in a different colour.
We basically need the conditional format by formula ability we have in Excel.
RE: Conditional Formatting throughout
The current possibilities of formatting in Power BI are too basic.
Why can I not color a whole line of my table regarding the text of a certain column in 2018 ?
(a matrix that I cannot rotate by the way)
RE: Conditional Formatting throughout
I was most disappointed yesterday to find that I could only use conditional formatting on a field that has had an aggregate function applied.
I could use AVERAGE in the one column I need, but then I end up with decimal places I don't want to see. Either need
1) conditional formatting similar to EXCEL
2) ability to specify the output format for numbers in a table
3) ability to turn off totals line for a given field in a table
RE: Conditional Formatting throughout
I cant believe this request is still going. I've just completed a large Power BI project and the lack of decent conditional formatting has held us back massively. In fact, if it weren't for the fact we get access to Power BI via our corporate E5 licence we'd probably have been off to Tableau or Qlik because of this limitation. As a minimum Power BI desperately needs conditional formatting on text and on the totals in tables.
RE: Conditional Formatting throughout
I agree this should be available through out Power BI, including:
* available for market place visualization developers to use
* ALL value types, not just numeric
RE: Conditional Formatting throughout
this was in Qlikview version 9!! and is one of the most requested features by clients
RE: Conditional Formatting throughout
You should be able to write a proper expression to control the format. In fact you should be able to write an expression behind every single property, just like in SSRS.
RE: Conditional Formatting throughout
It would be great to have conditional formatting allow for color formatting based on TRUE/FALSE results.
RE: Conditional Formatting throughout
Conditional Color formatting should exist.