Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 @Anonymous 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 @Anonymous 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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.