Forum Discussion
Helper IColor the Row titles based off a specific field
Hi niemis
Conditional formatting is functionality that applies only to values and totals.
Furthermore, the headings of rows cannot be separated into different colors.
Alternatively, you can build a measure to give a category, add it to the matrix, and then apply conditional formatting to it.If this helps the steps you can follow:
1. create measure :
subCatvalue = if(ISFILTERED('Table'[SubCat]), SELECTEDVALUE('Table'[SubCat]),"")2. put it as value to the matrix3. Format it based on first level category
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helper IThank you Ritaf1983. I don't know that this would work. I may not have explained what I needed very well. Here's a larger screenshot. I need to remove the row sub titles 'Tier x' and I was trying to color code the data underneath those titles. So anything under a Tier 2 row heading would be green, Tier 3 would be yellow, etc.
As you can see I've got conditional formatting on the columns. I'm just baffled at what to do with the rows. Thank you.
