Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have a table that contains columns like date(including year, month, date, hours), temperature and other columns. I want to analyze the data for specific hours of each day. For example, Temperature values of lunchtime for the whole month. How can I do that?
Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, you can use HOUR function to extract the hour.
I want to make a visualization using the temperature values of specific hours For example, (from 12:00 - 13:00)for the whole month.
Right, so you would create two columns:
Month = MONTH([Date])
Hour = HOUR([Date])
Then just put both of these in the x-axis and you can drill down.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |