Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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.
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |