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). I understand that theres not an option to highlight specific items but i am wondering if anyone has a workaround. My table looks somewhat like this: 

 

Revenue 

Staff cost 

Overheads 

Claims 

Gross margin 

Expenses

proceeds

Profit

 

 

Thanks all for your suggestions! 

 

 

  • 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