How do I get a line graph for every day of the week

[brawndo]

Hello All,

I'm trying to get a graph like the one shown below. Any ideas how to achieve this? The data I'm trying to manipulate is electricity usage in 15 minute intervals. So you'll see in the graph that on every day of the week power concumption dips during that time frame. Any help with this would be greatly appreciated. Thank you!

 

[Anonymous · Accepted solution]

Hi @brawndo ,

Creating a calculated column like

Weekday = FORMAT([Date],"dddd")

It can also be done in power query

Date.DayOfWeekName([Date], "en-US")

Reference: Date.DayOfWeekName

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @brawndo ,

You can use unpivot to achieve it.

In the Power Query, select all time columns at the same time.

Then you can use the line chart to get what you want.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@brawndo , Create a Weekday in your table use that. And use that as legend?

Weekday = Format([Date], "ddd")

[brawndo]

Thank you so much. One final thing i need to solve is instead of displaying 1, 2,3 etc.. Make it show the Actual day of the week. For instance instead of "1" It'll show "Monday". I can't do it through Power query since the column I'm working with is a calculated column. Thank you

[brawndo]

I included a snap of the data I'm working with. The top row is the 15 minute interval I mentioned in my original post.