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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.