Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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,
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |