Forum Discussion

niemis's avatar
niemis
Icon for Helper I rankHelper I
3 years ago
Solved

Color the Row titles based off a specific field

I created a matrix table in power bi desktop.  In my Rows, I have text 'Tier x', for Tiers 1, 2 and 3.  Beneath each Tier is a specific application.  I want to change the color of the application nam...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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 matrix

    3. Format it based on first level category

    Link to a sample file 

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

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

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 matrix

3. Format it based on first level category

Link to a sample file 

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