The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Good day All,
Please I need help on the following.
I have my excel sheet already loaded to power bi model. From the screenshot attached, I was able to display each member's details/info showing the clock in time and date. Clock-in is to be done 3 times a day. i.e, 1/12020: Time in: 8:00, Lunch: 12:00 and Time out: 4:00. When I tried displaying it on a table visual, it shows 3 entries on the table. Is it possible for the date to be grouped per day instead of the table displaying the Same date 3 times? Note that each clock in time has its own section as shown in the attached image below. Don't know if my question is clear enough.
Thanks as I await responses.
From the above image, the date should be grouped based on the entry. i.e, Day 1 has 3 entries, I want all three entries to be shown in a table row, same as day 2.
Thanks.
Hi @fsadiq
Can you show me how you want the date to be grouped per day with your expected result?
Best Regards
Caiyun Zheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
80 | |
75 | |
52 | |
50 |
User | Count |
---|---|
133 | |
124 | |
78 | |
64 | |
61 |