Hello, I have a visualization that I would lime to break data down by hour. How do I keep the AM and PM together instead of grouping by number? Here is what I have below:
I would like to see the data by 1AM, 2AM. 3AM and 1PM, 2PM, 3PM ect. Thanks
Hi, @gherbert1
You can refer to @Greg_Deckler reply, or you can use sort by column feature if the Updated_User is column.
Best Regards,
Yang
Community Support Team
If 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
Hi, @gherbert1
You can refer to @Greg_Deckler reply, or you can use sort by column feature if the Updated_User is column.
Best Regards,
Yang
Community Support Team
If 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
@gherbert1 Depends on the format. If they are text, you could create a new calculated column like:
AMPM Column = RIGHT([Time], 2)Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
