Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MichaelSeery
Frequent Visitor

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.

MichaelSeery_0-1676841835406.png

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.

MichaelSeery_1-1676841895264.png

My Set up

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

MichaelSeery_2-1676842105342.png

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 2
v-xinruzhu-msft
Community Support
Community Support

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.

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?

MichaelSeery_0-1677017514518.pngMichaelSeery_1-1677017535870.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.