Conditional Formatting on Total and Null Values

[Kray]

Hello ,

I want to apply conditional format to total value, and i dont want to see any format if value is null(number/zero) 

How can I do this?

 

[v-ljerr-msft · Accepted solution]

Hi @Kray,

I don't think there is an option to format Total Value in Matrix visual currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature.

To not format blank/null values, you can set "Don't format" for Format blank values option when configuring conditional formatting for a field. 

Regards

[Farhan123]

This option not available any more, how can we format null values now??

[Anonymous]

I have written on a workaround solution you can follow : Conditional Formatting and Sorting with Null Values in a Power BI Table | by Kanishka Randunu | May,...

[SathiMathi]

You can Achieve this formatting using the following trick.

http://sahayasathish.blogspot.sg/2018/05/poer-bi-conditional-formatting-on.html