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
johnyip
Super User
Super User

Apply different background color for different "rows" in matrix visualization

I have some formatting issues using PowerBI's matrix. I will show what I have achieved in PowerBI and the ideal formatting as below:

 

johnyip_0-1693981615432.pngjohnyip_1-1693981639135.png

As shown, my ideal formatting is to have different background color for the first 5th "columns".

However in PowerBI, at most I can have one single united color for all the "column" (i.e. "Rows" in the matrix).

 

Are there any ways I can format like Excel in PowerBI using matrix? I will not switch using table because the required layout won't accept duplicated value shown on each row (i.e. repeating the same branch name for row 8 to 11 if you use the Excel's ideal format as an example).

 

Thanks.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!
0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.