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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
potlurism
Frequent Visitor

How to implement alternative colors in power bi matrix rows

Sample.jpg

  Hi ,

Applying alternative row banding in a power bi matrix is proving difficult for me.In a power bi matrix, I was unable to get the above alternate colour banding.

Can you assist me with this?

I am using Financial Sample.

 

Regards,

Subbu

6 REPLIES 6
potlurism
Frequent Visitor

Hello, Rajulshah
I appreciate your prompt reply.I've applied the alternative background colour in response to your remarks. However, I want to apply all of the rows based on each row's COGS value.

 

Power bi  Sample.png

Hello @potlurism ,

 

First, convert this matrix to table and give your alternating colors.
Then, convert this table to matrix. I was able to do that.
Please try and let me know.

Hi, Rajulshah,

 

I continue to struggle to succeed. Would you mind sharing the.pbix.

PFA.

Regards,

Subbu

Power bi  Sample.png

 

@potlurism ,

 

You can see the report here.

I appreciate your suggestion.
It is focusing on a single  dimension and measure,  Imagine that you have a measure and multiple  dimensions. When "Steeped layout is OFF" . In this case Alternate row banding is not working?

Can confirm row banding is will work on grouped columns in matrix.

Power bi  Sample.png

rajulshah
Super User
Super User

@potlurism 

 

Go to Format Visual pane > Values and you can use the below:

rajulshah_0-1682514432284.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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