Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |