problems with tables in excell

[nonoliem]

I have an Excell table with energy consumption per date-time(15 minutes intervals)-day of the week.

When trying to make visualizations in the desk top, powerBI show/reports the data not in a normal sequential such as january through december and/or 01 january 2014 through 31-12-2014. Instead it shuffles dates, times in a inorderly manner so it seems.

I therefore can not or donot know how to make a dashboard where you van make a slections such as for example: month january, date 1 thru 15, time 00:00 thru 8:00.

Can someone can give me advise on this?

[Seth_C_Bauer]

@nonoliem In order to sort your dates, and use time to analyze your data in a better way, you want to create a date table. If you are importing your data into Power BI, here is a really straightforward blog on how to accomplish this. At the end it explains your issue, you need to sort by a different column to force the dates to align as expected. When you have the date table created, just create a relationship between your date column in your table to the date column in the new date table. This will allow you to look at your data in multiple different ways across different time segments.