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 terminology "Measure" in Power BI, I don't have the luck to get this to work on a "Measure", which is preferred from my point of view, instead of creating calculated column. Did anyone succeed in using a "Measure"? My experience is it is simply not selectable.
Color formatting by field value
You can use a measure or a column that specifics a color, either using a text value or a hex code, to apply that color to the background of font color of a table or matrix visual. You can also create custom logic for a given field, and have that logic apply the desired color to the font or background.
Regards
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.
3 Replies
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.
The dropdown menu did not allow me to add this measure.
