Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |