Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

conditional formatting in tables

It was implemented in charts but not in tables or matrixes.
Status: Completed
Comments
jjblanco
Advocate II
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.
Dan_Ahlvin
New Member
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.
masam
Regular Visitor
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
juan_ruiz1
New Member
Formatting size of values also will be great!
PatrickPilz
Advocate II
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
juan_ruiz1
New Member
Formatting color of columns individually will be useful.
starmoonknight
Helper II
Alternative colouring is good, but it is even greater that conditional formatting could be applied to table/matrix as well. Also, wondering whether a specific record/row could be highlighted while hovering
shabana
New Member
The option to be able to format the color of the table cell based on a calculated/previously defined value... That would be very helpful.
tblasko
Regular Visitor
Guys, as a PDM myself I just want to say that the work your doing is amazing. This one is a top priority for me and for my team. Everyone is using excel with heat mapped columns. So it would be 4 or 5 columns, with a variance column at the end, and that variance column would be heatmapped. Or also could contain the spark charts underneath. Would be big.
alex_stoyanov
New Member
Yes, need it badly for my green/yellow/red dashboard!