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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
77 | |
72 | |
49 | |
47 |
User | Count |
---|---|
159 | |
86 | |
80 | |
68 | |
66 |