Forum Discussion
Post PatronMatrix tables Alternate colors with 2 rows.
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!
Super UserWresen 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.
Post PatronHi 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!- Wresen
Thx so much grazitti_sapna
I totaly missed that 🙂