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). 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
8 Replies
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,
JHi 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. 🙂
Hi Anonymous
you can create a column (column1 in my example) in this table which will have value="red" for your selected columns and be blank for other.
then use the conditional formatting function (vizualization pane - values - column - conditional formatting - background):
Result will look like this
do not hesitate to give a kudo to useful posts and mark solutions as solution
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. 😂
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.
There isn't a direct way to highlight entire rows based on specific values in Power BI matrices, but you can achieve a similar effect using conditional formatting.
Conditional Formatting Based on Slicers
For more details check: https://inforiver.com/blog/general/supercharge-power-bi-conditional-formatting/
YouTube: https://www.youtube.com/watch?v=WF7fCAmjjZc
