Extracting Hour data values

[Anonymous]

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?

[Greg_Deckler]

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.

[Anonymous]

[Anonymous]

I want to make a visualization using the temperature values of specific hours For example, (from 12:00 - 13:00)for the whole month.

[Greg_Deckler]

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.