Forum Discussion
Solved
Formatting a Matrix
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,
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.