Forum Discussion
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...
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
My suggest would be to create a grouping table in excel then relate it to your data then you can set up stacked rows much like I did here:
They will automatically be bolded and then you can use conditional formatting by clicking the drop down arrow in the visualizations fields box as the other responders have suggested. This is what the excel looks like. The numbers relate to the office name and the office names all fall under regional jurisdictions. You can use the same concept for accounts falling under sections of a financial statement.
If this works for you please accpet it as the solution. Got to get them badges. 😂