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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
andershs
Frequent Visitor

Matrix-visual: Colour layout of last dimension (column) in Rows

 

Hi all

A minor issue, we have encountered repeatedly without being able to correct it.

When we use the Matrix-visual in Power BI Desktop, the last dimension added to Rows will have the same alternating colour as the values in the visual. I would expect the last Rows-dimension to follow the visual representation of the other dimensions added in Rows - in this example they should have a black background colour with white text, and not alternate like the Values do.

 

When we drill down, this behavior is consistent for the last dimension on display. It follows the alternating row colours of the Values and not the colours of the other dimensions in Rows.

 

This might be due to some settings we are not familiar with.

 

andershs_0-1672826545001.png

Thanks!

2 REPLIES 2
Anonymous
Not applicable

Hi  @andershs ,

When you are in the Format – Style presets – Alternating rows will show.

vyangliumsft_0-1672894014197.png

vyangliumsft_1-1672894014201.png

You can adjust it to Format – Style presets – Bold header.

vyangliumsft_2-1672894014202.png

The last row of dimensions has a black background color with white text.

vyangliumsft_3-1672894014205.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Liu Yang

Thanks for your response. It is really appreciated.

 

I have played around with the Style presets, and am actually using Bold header flashy rows. But it has the same visual layout as the Alternating rows.

andershs_0-1672906626575.png

 

Do you know, is this just part of the design of the style presets Alternating rows and Bold header flashy rows?

I can't think of a situation where your would want the alternating rows to also include the last column of the Rows dimensions. But this is just my uneducated opinion 🙂 There might be a very good reason for it, that I do not know.

I would actually like a mix of the two. Get the black background colour of the Bold header for all Rows dimensions and get the changing row colours of the Alternating rows for all Values. Do you know if this is possible?

Like this mockup:

andershs_1-1672907577099.png

 

BR

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors