Metrics to display increase

Hi chriswoodiow,

Thanks for reaching out to the Microsoft Fabric Forum Community.

You're seeing the same increase icon for all rows because you're applying conditional formatting based on a static count field, which doesn't calculate the change per building or ship. To fix this, you need to create separate DAX measures that calculate the month-over-month change for each metric (like incidents or audits) per building/ship. Then, create another measure that returns 1 if the value increased and 0 otherwise. Use this second measure as the basis for your conditional formatting, not the raw count. This way, each row will correctly show an up arrow only if that specific building's value increased compared to the previous month.

If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

Best regards,
Prasanna Kumar