Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
GJUDGE
Helper II
Helper II

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,

 

GJUDGE_0-1633681873931.png

 

1 ACCEPTED 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

View solution in original post

4 REPLIES 4
PowerBI_guy
Advocate I
Advocate I

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.

 

goncalogeraldes
Super User
Super User

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:

goncalogeraldes_0-1633682731196.png

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:

 

GJUDGE_0-1633683217203.png

 

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.