Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

highlight specific rows in matrix

Hi All,    I have a table and would like to be able to highlight certain rows. I would like to be able to bold or use a background colour on the bolded items like revenue and profit (as shown below...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    You can use conditional formatting but you will need to apply it to each column in your table:

    Formatting = IF(SELECTEDVALUE('Table'[Column2]) = "qd" ; 1 ; IF( SELECTEDVALUE('Table'[Column2]) = "2q" ; 2 ; 0 ))

    Hope it helps,
    J



tex628's avatar
tex628
Community Champion
6 years ago

You can use conditional formatting but you will need to apply it to each column in your table:

Formatting = IF(SELECTEDVALUE('Table'[Column2]) = "qd" ; 1 ; IF( SELECTEDVALUE('Table'[Column2]) = "2q" ; 2 ; 0 ))

Hope it helps,
J



Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is an excellent workaround. The only issue here is that it needs to be applied to the remaining columns. 

 

Thanks so much!