Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
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,...
You can Achieve this formatting using the following trick.
http://sahayasathish.blogspot.sg/2018/05/poer-bi-conditional-formatting-on.html
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |