Conditional fomatting isn't working on some rows

[william0076]

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

[amitchandak · Accepted solution]

@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]

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.