Forum Discussion
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
- AnonymousNot 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.
- MichaelSeeryFrequent 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?