Forum Discussion
How to Change the different color for Row header in Matrix Visual
Hello Team,
We are using Matrix visual in Power BI Report, which having three hierarchies in row headers as shown below:
The issue is, We need to change backgroud color and font color to first two row headers as below (Which we did already).
We also need to change the font color for third row header as "Purple", But unfortunately I am not able to do that.
Please suggest any solution for this. We are also using embedded Power BI license, So we can do this by backend as well????
Thanks.
Hi AtulsDream
Unfortunately, we don't have a conditional formatting functionality on matrix rows.
There is an idea about this issue please vote for it here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b02bce75-4528-ec11-b76a-281878e62223This option is available at inforiver visuals, but for pay:
https://community.inforiver.com/tips-tricks/post/conditional-formatting-of-whole-table-rows-using-inforiver-matrix-eN0yiGTvjIKCyNWhttps://www.youtube.com/watch?v=WF7fCAmjjZc
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello All,
I have resolved this issue.
To change the color of first and Second Hierarchy (i.e, Agency Desc and Agency Group Desc), I have make the changes as below:
1. From Row Header option, changed the Text and Backgroud color as required.
2. Keep the Branded row color setting as ON
3. To change the color of third hierarchy (i.e Indicator Desc) I have change the setting as below:
4. It will change the text color for all available values., If we dont want other columns with same color, we can easily change text color from Specific Column setting.
Thanks.
2 Replies
- Ritaf1983
Super User
Hi AtulsDream
Unfortunately, we don't have a conditional formatting functionality on matrix rows.
There is an idea about this issue please vote for it here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b02bce75-4528-ec11-b76a-281878e62223This option is available at inforiver visuals, but for pay:
https://community.inforiver.com/tips-tricks/post/conditional-formatting-of-whole-table-rows-using-inforiver-matrix-eN0yiGTvjIKCyNWhttps://www.youtube.com/watch?v=WF7fCAmjjZc
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello All,
I have resolved this issue.
To change the color of first and Second Hierarchy (i.e, Agency Desc and Agency Group Desc), I have make the changes as below:
1. From Row Header option, changed the Text and Backgroud color as required.
2. Keep the Branded row color setting as ON
3. To change the color of third hierarchy (i.e Indicator Desc) I have change the setting as below:
4. It will change the text color for all available values., If we dont want other columns with same color, we can easily change text color from Specific Column setting.
Thanks.