Conditional Formatting - I want to color the total in red even if the value is not zero

[sonalisaha2310]

I have matrix visual , to get the colour of the total as red, if the values inside it it 0

for example

- A	10	8	4	2	12
-  AA	5	4	2	1	6
AAA	5	2	1	1	0
AAAA	0	2	1	0	6
+BB	5	4	2	1	6

Consider the above matrix visual , i want to highlight the total in red as well if the value inside it is 0 as shown in an example of AA

[Joe_Barry]

Hi @sonalisaha2310 

Please add + 0 to the measure that you are using in the visual, if you are just adding a column from a table to calculate, then please create a measure. The +0 will help show data if the resultof the measure is BLANK().

In the conditional formatting of the visual in cell elements, there is an option to put the conditional formatting on both Values and Totals, please activate this and you should get the result you need.

Joe

[Anonymous · Accepted solution]

Hi @sonalisaha2310 ,
Thanks to @Joe_Barry reply.
Based on your description, you want to include subtotals for columns with a value of 0 for custom formatting. However, the current power bi desktop only supports custom formatting for value fields. So, you can try to set an identifier for the subtotal to highlight. Here is the sample data and measure

Create measure

Color.1 = 
IF(
    ISINSCOPE('Table'[Second Level]) && SELECTEDVALUE('Table'[Value.1]) = 0 ,
    "Red"
)

Create measure for each column
Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly