Conditional Formatting throughout
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.
Please release conditional formatting on Donut / Pie chart visual ASAP
conditional formatting on donut chart
Carlos Zucco commented
Another point to consider conditional formatting: tachometer's range colors.
I hope I'm not duplicating other comments. It would be great to also add conditional formatting for bar chart's label and axis that allows set up based on a measured or calculated columns.
Conditional Formatting of field names would be awesome - then I could make my reports / charts really multi-lingual.
I think we need the Conditional Format in all the visual objects, this would open the doors to many opportunities of personalization of our reports
Really need this for dates. Greater than or less than Today() specifically...
This is a must for dates. Particularly relatively (i.e. within the last month)
Conditional Formatting is vital across all visuals please.
Jose Garcia commented
Would be great to add same conditional formatting capabilities as in SSRS
Conditional formatting desperately needs to be updated. I can't believe I can do so many powerful things with this product, but easily coloring text red if the date is older than X years (for example) isn't one of them. It is extremely frustrating.
Additionally conditional formatting across rows instead of columns needs to be incorporated.
This is a must. The data bars in matrix/tables need more color options (such as based on defined value ranges) 0-6 RED, 7-8 AMBER, >9 GREEN
I desperately need to be able to conditionally format the segments of a pie chart
Conditional color formatting on PIE/Donut charts would be extremely beneficial. Color banding depending on fill value. eg,
>80% = Green
>60% = Yellow
<59% = Red
Adding conditional formatting to the background of a report would be extremely beneficial as well. We are attempting to create a dashboard that is displayed on SharePoint Online where the 'heat' boxes would have made the live dash much more dynamic.
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 <RED COLOUR>
IF value is 1 then <YELLOW COLOUR>
IF value is 2 then <GREEN COLOUR>
shame about pie charts, hope that comes soon!
Jack Wells commented
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.
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)
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