Conditional formatting Grand total in a matrix

[rafajammali]

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.

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.

[kaisrec]

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-rules-for-totals-and-subtot...

[amitchandak]

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

[corange]

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]

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