Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Thanks!
Hi @andershs ,
When you are in the Format – Style presets – Alternating rows will show.
You can adjust it to Format – Style presets – Bold header.
The last row of dimensions has a black background color with white text.
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.
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:
BR
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |