Forum Discussion
Conditional Formatting in table by field value
Hello, I am not sure if I misunderstood the Microsoft Document (https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting), which says it can be a measure. If it means the te...
Hi Anonymous ,
One sample for your reference. Please check the following steps as below.
1. Create a measure as below.
Measure = VAR a = SUM ( 'Table'[value] ) RETURN SWITCH ( TRUE (), a <= 12, "#143DFF", a <= 14, "#FD09DE", "#DE8F12" )2. Format the visual by thea measure as below.
Hi Anonymous ,
One sample for your reference. Please check the following steps as below.
1. Create a measure as below.
Measure =
VAR a =
SUM ( 'Table'[value] )
RETURN
SWITCH ( TRUE (), a <= 12, "#143DFF", a <= 14, "#FD09DE", "#DE8F12" )
2. Format the visual by thea measure as below.
Thanks. The dropdown menu didn't show up the measure at the begining until I draged and dropped the measure to the visual then it was able to locate it. Of course I then dropped the unwanted measure later. It's a bit strange as I don't have to perform the additonal step to find the measure.