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
mroomi
Helper II
Helper II

Need to create KPI for student

Hi,

I want to create KPI for student enrollment, I have total count of enrooled student. What I want to do is to add a date filter(slider) so depending upon the selection of the year my graph shows todays Vs selected year enrollment data.

In order to achieve (Date slider working with enrollment data) this what do I need to do?

 

Thanks

Roomi 

1 REPLY 1
v-sihou-msft
Employee
Employee

@mroomi

 

I assume you already have the fact data table for that KPI on date granularity. You should add a Year column in your table, then create a calculated measure to have the calculation group on Year level.

 

Year enrollment =
CALCULATE ( SUM ( Table[enrollment] ), ALLEXCEPT ( Table, Table[Year] ) )

Regards,

 

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.