cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)