KPI Card Target Chart Not Showing

[MichaelSeery]

Hello...I am looking for some help to understand KPI cards.

I have set up a KPI card to compare currrent month's total to last month and it appears to be working correctly.

However, when I filter for another month end date, I get the values but not the chart showing in the KPI card.

This shows the KPI card correctly however, when I click on another EOM in the table I get the correct values but not the chart.

My Set up

I have a calendar table that has a relationship to the Aging table

And I have a couple of measures that use the Calendar table.

Meassures

31+ = CALCULATE(SUM('AR Aging'[31-60]) + SUM('AR Aging'[61-90]) + SUM('AR Aging'[91-120]) + SUM('AR Aging'[121+]))

31+ LM =

VAR CurrentMonth = SELECTEDVALUE('Calendar'[Month])

VAR CurrentYear = SELECTEDVALUE('Calendar'[Year])

RETURN

SUMX(FILTER(ALL('Calendar'),

IF(CurrentMonth = 12,

    'Calendar'[Month] = 1 && 'Calendar'[Year]= CurrentYear -1,

    'Calendar'[Month] = CurrentMonth - 1 && 'Calendar'[Year]= CurrentYear)),

[31+])

Any help would be very much appreciated.

[v-xinruzhu-msft]

Hi @MichaelSeery 

It may be because you didn't sort by FiscalMonth. KPIs don't have a sort option. You'll need to start again and sort by FiscalMonth before you convert your visualization to a KPI.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MichaelSeery]

Thanks for taking the time to help.

I believe I have sorted by FiscalMonth and the data is appearing correct on the KPI.

It's just not showing the chart.

How do you suggest I sort?