Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Using measures to group dates alongside with other information on visual table

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. datadatatable visualtable visual

Frequent Visitor 


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.



Community Support
Community Support

Hi @fsadiq 

Can you show me how you want the date to be grouped per day with your expected result?


Best Regards

Caiyun Zheng


Hi @v-cazheng-msft ,

Kindly see the attached image. 



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors