Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 41 | |
| 22 | |
| 17 |
| User | Count |
|---|---|
| 183 | |
| 114 | |
| 93 | |
| 62 | |
| 45 |