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 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!
Solved! Go to 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.
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.
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.
@brawndo , Create a Weekday in your table use that. And use that as legend?
Weekday = Format([Date], "ddd")
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
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.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |