Forum Discussion

astartes6's avatar
astartes6
New Member
1 year ago
Solved

Help with Row Subtotal Background Color

Hello,  I am having an issue setting the background color for subtotal rows in a Matrix similiar to the one below: *Using proxy values as the actual data is work sensitive*   Using the Subto...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi astartes6 

     

    You can use conditional formatting but please  take note that conditional formatting can be applied to values only  - not row or column categories.  In the screenshot below, I am applying a yellow color fill to the Apparel and Homegoods category rows using conditional formatting. Please note that the colors are not applied to the categories and if there are blank values, they won't be applied to the cells with blank values as well.

    Selective Conditional Formatting = 
VAR __SelectedCategory =
    SELECTEDVALUE ( Category[Category] )
RETURN
    IF ( __SelectedCategory IN { "Apparel", "Homegoods" }, "yellow" )

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi astartes6 ,

First of all I couldn't agree more with danextian, again I have some of my own opinions.

I create a table and make it into the matrix.

Then I think you can color what you want.

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.