Forum Discussion

rafajammali's avatar
rafajammali
Frequent Visitor
6 years ago

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 res...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

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's avatar
    corange
    Post Patron
    6 years ago

    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