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
Yes, need it badly for my green/yellow/red dashboard!
RE: conditional formatting in tables
Formatting color of columns individually will be useful.
RE: conditional formatting in tables
Formatting size of values also will be great!
RE: conditional formatting in tables
even simple stuff, like negative values in red. Usually I want them applied to a measure, similar to the way you can do it in PowerPivot with the measures
RE: conditional formatting in tables
As others may have said before with other words, conditional coloring of individual cells based on ranges (when values are numeric) will also be extremely useful.
RE: conditional formatting in tables
Being able to select a palette of colors for stacked bar charts would make them very useful. For example, if you have 3 measures in each stack, and a conditional criteria for the sum of all three measures. So if the stacks are 'exceeding' all three measures are different shades of green, if they're 'meeting' they're three different shades of yellow, and if they're lagging they're three shades of red.
RE: conditional formatting in tables
Matrix without grid lines is useless and almost impossible to read large data set.
I wonder how Microsoft wants Excel and BI users to use Power BI without such basic formatting functions.
Why Microsoft keep reinventing the wheel and every single time forget such basic functionalities.
Please add grid lines plus column and row colors which can further be customized - and ASAP.
Thanks
RE: conditional formatting in tables
What I'd also like is a stepped color palette. Thresholds I'm dealing with are if values fall in 3 different ranges and to make values in those ranges at red, yellow or green. My leads don't needs to see dozens of different colors because values are spread throughout the diverging spectrum
RE: conditional formatting in tables
It would be nice if able to mark the first say 10 column in red and some other 5 column in green and specify what it indicates that makes it more comfortable to analyse. In SSRS we have an option to customize table with expressions like we want to. Something more user friendly will work.
RE: conditional formatting in tables
Hooray! Can't wait. Needed this again just yesterday.