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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
william0076
Frequent Visitor

Conditional fomatting isn't working on some rows

Hi guys,

 

I've set conditional formatting as:

an arrow down if it's below 5% of the % vs LY Green if above based on % vs LY. However some of the rows are not detecting any conditional formatting even though the data is there and showing. Any reason why it might be showing any contiional formatting for the highlighted rows (yellow)

 

Thanks

Will

 

william0076_0-1610964684096.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@william0076 , Can you share the conditions?

Also, check it is a % column then 0.05 is 5 %

 

You can also create a color measure and use the same in conditional formatting using field value option

 

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

 

Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://youtu.be/M5PvQUy-L_4?t=531

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@william0076 , Can you share the conditions?

Also, check it is a % column then 0.05 is 5 %

 

You can also create a color measure and use the same in conditional formatting using field value option

 

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

 

Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://youtu.be/M5PvQUy-L_4?t=531

Anonymous
Not applicable

Hello, 

Can you share the table structure, dax code and conditional formating page? So we can help you better for this problem. It seems like your formatting cant see the rows it need to be see.

 

thank you. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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