Forum Discussion
Post PatronMatrix tables Alternate colors with 2 rows.
Hi and thx for reading this .
Is it possible to get the Alternate color also in the Fruit column ??
It is a Matrix table with 2 rows, In Layout and style presents its "default and Tabular", i have also turned of > +/- under "Row Headers"
/Thx
Hi Wresen,
Just turn on the toggle Repeat rows under Layout and style preset
Attached is the sample .pbix file for your reference.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
5 Replies
- InsightsByV
Super User
Hi,
Please check below links:
https://community.fabric.microsoft.com/t5/Desktop/Alternate-matrix-row-colors/m-p/2968411
If the matrix is not much complex you can also consider converting it to a table which will provide you more control over formatting.
Let me know if that helped!
- Jai-Rathinavel
Wresen It is possible to dynamically color the rows based on the Color column. Follow the below steps
1. Create a measure to capture current rows expected color. Format it as text
Selected Color = SELECTEDVALUE('Table'[Color])2. Now select the matrix and navigate to Cell Elements option under Format Visual
3. Enable Background Color and Click fx
4. Select Field Value and then the Selected Color measure
5. Now your matrix should look like below.
WresenHi Jai-Rathinavel
i am sorry for i have not been clear in what i mean.
The color column has noting to do with the alterante colors (its just my made up data)
I want the Matrixs Alterante color to expand to the "Fruit" column.
Apple should be White as it is
Banana should be Greyis at the row is for it
Pear should be White
Watermelon should be Greyish
basicly the matrixs alterante color as set under "Values" should expand to the Fruit column
/Thx- grazitti_sapna
Hi Wresen,
Just turn on the toggle Repeat rows under Layout and style preset
Attached is the sample .pbix file for your reference.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
