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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
TaufikMaggangka
Helper II
Helper II

Usage by daily, monthly and yearly

Hi all, 

Please if someone can help. Basically, I want to create chart visualization of class usage from attendance of student by daily, monthly and yearly.

I have create a sampel data on the excel below link. Let me know if you need for future data.
https://1drv.ms/x/s!AkqCbqtIUWCygRBSKRPloMujejwA?e=FE92Al



Your support really appreciate. Just stuck on this things for few days and I can got correct number.




4 REPLIES 4
amitchandak
Super User
Super User

@TaufikMaggangka , You can join the date with a date table having - Date, Month, year, etc and can use count(Table[ID])  for attendance.

 

You can use hierarchy to drill down or create different visuals 

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak ,
To be honest I didnt really understand what you mean. Would you like to give me an exampel pbix ?

Your future help will be really appreaciate

@TaufikMaggangka , Check if the file attached after signature can help 

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak ,

Tahnk you so much for your help, But i have an issue when i try to create gaue with filter by year and month. The result always 100%.

But it working properly by day and monthly.

Your future help will be really appreciated.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.