Forum Discussion
Time groupings
I've got an issue where within our business we need to produce a table showing the volume of data we are receiving by the hour during the business hours but we want to group the non-business hours into one group on the same table. Is there a way to get the below showing in one table.
00:00 - 08:00 - all volumes showing in one column
08:00 -18:00 - all volumes showing with one column per hour
18:00 - 00:00 - all volumes showing in one column
Below is an example of the current table.
Hi Nathan8891 ,
Consider grouping the column fields of the matrix:output:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
1 Reply
Hi Nathan8891 ,
Consider grouping the column fields of the matrix:output:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group