Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |