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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Conditionals by Row Category in Matrix

Hi, I have a matrix that measures the completion rate of POs by weekday, what I need to do is to set a conditional formatting by row category, meaning that each PO Category should contain different parameters of color coding, for example, for PO Cancel, if %>=75, green; else if %>=50, yellow, else if %<50, red.

 

Another tricky part is that I have independent columns for each weekday due to the way the data is structured, so each column by day is independent from one another. 

 

emilianoalvz_0-1670366988779.png

 

Is there a way to apply conditional formatting by Row Category?

 

 

2 REPLIES 2
vicky_
Super User
Super User

I believe you should be able to change your measure and use DAX to specify the colours. See if this thread helps: https://community.powerbi.com/t5/Desktop/Customized-Conditional-Formatting-Using-DAX/m-p/733277

Anonymous
Not applicable

Yes, thank you! I actually ended up doing something very similar to that:

 

emilianoalvz_1-1670433117958.png

 

But I think this was possible because I had the days sepparately and I could reference them individually, not quite sure, but thanks!

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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