Forum Discussion
Adding color to rows in Matrix
I have the following data:
And I would like to create something on Power BI that looks like this (I have mocked up the image below on excel as an example):
So far I have used a matrix with all of the columns added in as rows on Power BI and then expanded (see below):
But I am having trouble adding in the colours to the rows. Can anyone help with ideas about how to do this?
Many thanks!
Hi Pob99 ,
To apply conditional formatting, select a Matrix visualization in Power BI Desktop or the Power BI service. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.
For more details, please refer to:
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Greg_Deckler
Community Champion
Pob99 You would have to set the Background conditional formatting for each row/column? and base it on the Pay Grade.
Thank you for your reply.
I am very new to Power BI so do not have much knowledge on how to set background conditional formatting for rows/columns or how to base this on another row (e.g. in this case Pay Grade). I have checked and I don't see any option for conditional formatting when I click on the measures themselves (see screenshot below). Would I need to use DAX to do what you suggest?
v-jianboli-msftCommunity Support
Hi Pob99 ,
To apply conditional formatting, select a Matrix visualization in Power BI Desktop or the Power BI service. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.
For more details, please refer to:
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
