cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HarperGuo
Frequent Visitor

Group date time data by date

Hi, I'd like to ask if I have datetime data, can I visualise the data by date on the fly without creating another date column? 

 

For example, data looks like this, with timestamp:

 

           id   timestamp               data  group 
27001   27242   2020-01-01 09:07:21.277 19.5    1   
27002   27243   2020-01-01 09:07:21.377 19.0    1   
27581   27822   2020-01-02 07:53:05.173 19.5    1   
27582   27823   2020-01-02 07:53:05.273 20.0    1   
27647   27888   2020-01-02 10:01:46.380 20.5    1   

Can I visualise "data" by date? 

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @HarperGuo 

Please correct me if I wrongly understand your question.

Without creating another date-table, or another time-table, or another date-column, and when you drag the timestamp column into the visualization, for instance like the below picture, it will automatically create date hierarchy Axis (Year -> Q -> M -> D), but not to the hour -> minute -> second level.

So, in my opinion, the answer is yes.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

 

Picture5.png

 

 

 

 

 


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

1 REPLY 1
Jihwan_Kim
Community Champion
Community Champion

Hi, @HarperGuo 

Please correct me if I wrongly understand your question.

Without creating another date-table, or another time-table, or another date-column, and when you drag the timestamp column into the visualization, for instance like the below picture, it will automatically create date hierarchy Axis (Year -> Q -> M -> D), but not to the hour -> minute -> second level.

So, in my opinion, the answer is yes.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

 

Picture5.png

 

 

 

 

 


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors