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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
v-yangliu-msft
Community Support
Community Support

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.