Forum Discussion
Conditional Formatting on Total and Null Values
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?
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. :smileyhappy:
Regards
4 Replies
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. :smileyhappy:
Regards
You can Achieve this formatting using the following trick.
http://sahayasathish.blogspot.sg/2018/05/poer-bi-conditional-formatting-on.html
This option not available any more, how can we format null values now??
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, 2021 | Medium
