Forum Discussion

MichaelSeery's avatar
MichaelSeery
Frequent Visitor
3 years ago

KPI Card Target Chart Not Showing

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      MichaelSeery
      Frequent Visitor

      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?