Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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.
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.
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-281878e62223
This option is available at inforiver visuals, but for pay:
https://community.inforiver.com/tips-tricks/post/conditional-formatting-of-whole-table-rows-using-in...
https://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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |