Format matrix background color.

[AnneTang]

Hello,

I have a matrix with Month as Column, Row drill down from Category -> SubCategory -> Products, and [%] as value.

Is it possible to set format the background color for Subcategory and Product?

For eaxample: If SubCategory is less then 10% different from Category then green, 11% - 20% then yellow, more then 20% then red.

Sme for Product. 

Thank you

[parry2k]

@AnneTang unfortunately you cannot apply the conditional formatting to the columns you have added on the row, but you can apply it to the value which ofcourse not what you are looking for.

On the other side, Table Visual does allow you to highlight value on the rows but it will also not work for you, because you will lose the drill-down functionality.

In nutshell, unfortunately there is no solution.

[foodd]

Please create a pbix file that contains some sample data but still reflects your data model (tables, relationships, calculated columns, and measures), upload the pbix to Onedrive or Dropbox, and share the link. If you are Excel to create the sample data instead of the manual input method share the xlsx as well.

Describe the expected results based on the sample you provide.