Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 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
6 years agoCommunity Champion
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
Hope it helps,
J
- Anonymous6 years agoNot applicable
This is an excellent workaround. The only issue here is that it needs to be applied to the remaining columns.
Thanks so much!
- Anonymous5 years agoNot applicable
Hi tex628: I have a similar situation that I tried to follow your solution, but having an issue. I posted it in:
If you could respond to that, would appreciate it a lot! Thanks. 🙂