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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors