Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can I format the matrix like the one below in Power BI so that all rows relating to a product have a different background and font colour?
Thanks,
Solved! Go to Solution.
Hello there @GJUDGE ! Unfortunately Power BI does not allow us to change the backgroung colour of rows in a matrix (other than with the conditional formating). As such, the solution provided by @PowerBI_guy is the only work around so far.
If this is a feature that you consider to be crucial in one of the next Power BI updates, please upvote this idea.
For additional help, please @ me in your reply!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
You could do this with a measure, though you would have to apply it to each metric within the matrix.
Colour Background =
VAR _CAT = SELECTEDVALUE(Product[Product Value])
return
IF(
_CAT="Product A","#E2EFDA",
IF(
_CAT="Product B","#FCE4D6",
"#D9E1F2"))
There may well be better ways, but off the top of my head, this would do the job.
Hello there @GJUDGE ! You can format the row headers for your matrix in the "Row Headers" options on the formating pane, like in the image below:
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
@goncalogeraldes Sorry if my original question wasn't clear, but I need it to look like the following:
Hello there @GJUDGE ! Unfortunately Power BI does not allow us to change the backgroung colour of rows in a matrix (other than with the conditional formating). As such, the solution provided by @PowerBI_guy is the only work around so far.
If this is a feature that you consider to be crucial in one of the next Power BI updates, please upvote this idea.
For additional help, please @ me in your reply!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |