Alternate row shading based on values

Question

Once again I am here to ask a question about a feature I would have thought would be standard.

In a table visual, alternate the shading of rows based on the value of one or more columns

AAA,1,BBB

BBB,1,CCC

So Rows AAA would be shaded, rows BBB not. Wash, Rinse, Repeat for the table visual.

amitchandak · Answer

Anonymous , You can use measure based conditional formatting, You have to do it for all columns/field in tbale and Matrix you can do it only for values 
&nbsp;
Switch( True() ,
Max(Table1[Colum1]) ,"AAA" , "Green",
"White"
)
&nbsp;
Use in background conditional formatting using the field value option
&nbsp;
How to do conditional formatting by measure and apply it on pie? https://www.youtube.com/watch?v=RqBb5eBf_I4&amp;list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8Lhttps://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

anonymous · Answer

Close, but not quite. The values are not predicatble and are many. Part numbers in a manufacturig system actually and thousands. So any solution that depends on specifying the value of the column is a non-started.

Forum Discussion

Alternate row shading based on values

2 Replies

Related content

Alternative to SWITCH ()?

New and Need Help - Alternating Rows

alternative chart power bi

Alternatives to QuickBooks connector post deprecation

incorrect Total Selected Value alternative