Forum Discussion
Advocate IHow to group data by day
Hi everyone,
Probably a simple question, but I could not find the answer after a lot of searching.
How do I display the data by a specific date,
So I would like to be able to have one heading for the specific date, then display all the data under the one row heading.
Or be able to expand each date/day with a plus sign next to it.
I do not want to summarise the rows in that specific date, just display all the rows for that date.
For example:
Hi Johannf78 ,
You can consider using the power bi tooltip to move the mouse over the date to display its grouping information
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
Or you can also consider using drill through: select a time of day and group by that time:
Result：
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Please click here for the pbix file
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Johannf78 ,
You can consider using the power bi tooltip to move the mouse over the date to display its grouping information
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
Or you can also consider using drill through: select a time of day and group by that time:
Result：
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Please click here for the pbix file
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Pragati11
Super User
HI Johannf78 ,
You can use a table visual in Power BI to display the data in the required format.
But this will depend on what data you have and how it is formatted? Have you got your data at a day granularity or not? etc.
Share some sample data, so that we can help further.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
