Forum Discussion
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
4 Replies
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 Geraldesgoncalogeraldes 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
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.
