marcelo on 21 Aug 2015 09:07:01
It was implemented in charts but not in tables or matrixes.
Administrator on 31 May 2016 23:23:27
We released conditional formatting in tables with our May release of Power BI Desktop. Give it a try and let us know what you think. You can learn more about how to use it in our latest blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/.
- Comments (166)
RE: conditional formatting in tables
It would be helpful if these are available in the matrix (2-way) table visual
RE: conditional formatting in tables
Hi,
Comment on "Conditional formatting not visible":
When you are applying the conditional formatting in a table, you have to make sure that the particular column is not as "Don't Summarize", otherwise conditional formatting will not be available. Also you can only apply conditional formatting on a single column.
It would be helpful to be able to apply conditional formatting on multiple columns at a time based on one column. Also would be helpful to be able to apply conditional formatting on a column based on other column that is not visible in the table.
Thank you,
RE: conditional formatting in tables
Hi Kim, i updated my Power BI Desktop S/w (May version) and Conditional formatting feature not visible. Can you help me on this. what to do?
First time i installed updates and Conditional formatting not visible, so i uninstalled Power BI Desktop s/w and installed latest (may) Version even though no luck.. plz help me on this.
RE: conditional formatting in tables
Please add to matrixes.
Please add absolute conditions, i.e. if below 0, RED, if above, BLACK.
Thanks for listening!
RE: conditional formatting in tables
This should absolutely be added to matrixes. Also if we could have it just highlight the top and bottom entry, that would awesome
RE: conditional formatting in tables
I am trying to use Matrix visual, and I wanted to display a date value in the Values box, but it is trying to Summarize the value (count). How can I not summarize it and display actual data value?
RE: conditional formatting in tables
Can you please also add the basic formatting options that are available in excel. For example an option to centre the values in each cell and change the colour of the text etc.
RE: conditional formatting in tables
hi! thanks for the great work,
will be happy to have this with Matrix also, plus the ability to define a more precise conditions for conditional formatting - greater than, above then and such...
RE: conditional formatting in tables
we need condtioanl formating in Matrix too ! Also there is need to have special format for special values like positives, negatives and under threshold or over threshold functionality..
RE: conditional formatting in tables
The conditional formatting is very limited since only allows the value column to be colored , it can't be apply to text string neither to Matrix Tables. Can you please extend the functionality?