Metrics to display increase

[chriswoodiow]

Hello, 

I am trying to get the individual metrics for the table below to show when they have an increase month on month but I can only get them all to increase or not at all

[v-pgoloju]

Hi @chriswoodiow,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

Hi @chriswoodiow,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution  it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @chriswoodiow,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[chriswoodiow]

This is how the raw data appears

[v-pgoloju · Accepted solution]

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

[v-pgoloju]

Hi @chriswoodiow,

Thanks for reaching out to the Microsoft Fabric Forum Community.

To display individual metric increases month-on-month in Power BI (as shown with the green up arrows in your matrix visual), you need to set up conditional formatting for each metric independently based on month-over-month comparisons. The issue you're facing (where all metrics show increases or none at all) usually happens when you're applying a shared measure or logic across multiple columns, rather than evaluating each column’s metric individually.

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

[chriswoodiow]

I did the following conditional formatting, I have tried applying to both totals and values also

But it gives it as a total for the reporting period. as apposed to by building/ship filter.