Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Saniat
Helper V
Helper V

Conditional formatting in Matrix - How to apply on Row and column totals ?

Hi,

I am using conditional formatting in Matrix, but could not get it in the totals.

Is there any way to do it ?

Many thanks.

Saniat_1-1692044251013.png

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Saniat ,

 

Not sure, but maybe the image below shows what you are looking for:

 

image.png

The above example is formatting the background color using the Field values formatting option, nevertheless, the Applies to property is available for all options though: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
foodd
Super User
Super User

In addition to @TomMartens suggestion, it came to mind Parker Stevens posted this in 2020

which I keep bookmarked to share when these questions come up.

 

Dynamic Conditional Formatting for Values and Totals in a Power BI Matrix

 

foodd_0-1692045747082.gif

 

 

TomMartens
Super User
Super User

Hey @Saniat ,

 

Not sure, but maybe the image below shows what you are looking for:

 

image.png

The above example is formatting the background color using the Field values formatting option, nevertheless, the Applies to property is available for all options though: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors