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
rafajammali
Frequent Visitor

Conditional formatting Grand total in a matrix

I am looking at changing color for the total field in a matrix table, the total field is a Column subtotal done in power bi formating.

I want to be able to change the color depending on the line results.

Capture.JPG

so basically if the first total is less than 100 then red if more then green, second total if less then 3 then green else red and so goes on.

4 REPLIES 4
amitchandak
Super User
Super User

You have to create a measure using allexcept that has the row total. Let assume row is view by region then

 

measure = calculate(sum(sales[sales])allexcept(Region[Region]))

 

The create a color measure on top of it

color = if(measure>=100, "green","red")

You can add more condition

 

Now in the format you have conditional formatting or background. When you hover you will see three dots or on the selection field, you will get conditional formatting. Open that and use the field option and choose the color measure.

 

You have to do this for all columns.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Hi @amitchandak , 

 

I am trying to apply your solution but I can't seem to figure out the second part where you talked about "Now in the format you have conditional formatting or background. When you hover you will see three dots or on the selection field, you will get conditional formatting. Open that and use the field option and choose the color measure.". 

 

Would you be able to insert a couple of screenshots here. i dont see the option to use the colour mesure as part of the conditional formatting, etc..

 

TIA

MFelix
Super User
Super User

Hi @rafajammali ,

 

Currently conditional formatting is not available for total or subtotals in the matrix/table visualizations. 

 

Is on the backlog of the development team. check the post below:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-f...


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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
Top Kudoed Authors