cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kray Frequent Visitor
Frequent Visitor

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?

 

frmatt.JPG

 formt.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-ljerr-msft
Microsoft

Re: Conditional Formatting on Total and Null Values

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. Smiley Happy

 

r1.PNG

 

Regards

View solution in original post

2 REPLIES 2
Microsoft v-ljerr-msft
Microsoft

Re: Conditional Formatting on Total and Null Values

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. Smiley Happy

 

r1.PNG

 

Regards

View solution in original post

Highlighted
SathiMathi Frequent Visitor
Frequent Visitor

Re: Conditional Formatting on Total and Null Values

You can Achieve this formatting using the following trick.

 

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,198)