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



Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the suggestion 🙂

 

I did consider that but do you know if the top level can be positioned to the bottom instead?

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You can put the subtotal at the bottom or the top, but the row label stays at the top of the group. I don't believe there is currently a way to change this. There are several ideas on the Power BI Ideas page for better financial statement templates and features, but currently that is "not what Power BI is intended for".

 

Power BI Ideas: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

If it is that important to you it may be worth checking out some of the Microsoft partners: https://powerbi.microsoft.com/en-us/partners/

 

I might recommend Zebra BI visuals: https://zebrabi.com/power-bi-custom-visuals/gallery/

We do not use these nor am I afiliated with them, but having seen them before they are very impressive.