Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am attempting to build a bar chart in Power BI that shows the max hourly value of every month. I had created a topic earlier; but it was 'solved' by an admin before i could attempt to try it myself: Link to previous post
What i have right now in Power BI is this:
How do i convert the X axis to Date & time for every month? For example: Jan 29, 6:00AM; Feb 28th, 5:00AM, etc? Here is my Power BI excel raw data:
I like the format of the "date/time" column for the x axis. "Total Rolling MWs" is the column where i am pulling the max monthly value from.
Thanks for your help.
Solved! Go to Solution.
I would like to share the soluntion with much thanks to parry2k's insight:
Firstly a measure is created to calc the monthly MW value:
Have you tried just pulling your Date/Time column into the axis under the month and using the expand down option?
Yes, I think your graph looks very similar to my graph posted in the OP. What i need is something more like this:
A graph showing the max hourly value on a per month basis. Thanks for the tip though 🙂
I am still stuck on this.... 😞
@Anonymous I guess not any more 😁
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous can you share the sample pbix file to get you the solution. Remove any sensitive information before sharing.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I would like to share the soluntion with much thanks to parry2k's insight:
Firstly a measure is created to calc the monthly MW value:
I am unable to publish the Pbix file via dropbox nor OneDrive as my organization has the "anyone can see link" greyed out. If you are willing to recreate a 2-3 month period with random total values, that would work for me? Thank you for your help.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |