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.
Hi, I know there are several threads about this already but I've read them all and I can't get the da*n Moving Average to work.
After some work I've come to some data like this:
These are different zones, the hours spent on some project in each zone and the date. Ideally, I'd like to get a line chart with the 7-day moving average of the time spent in each zone (so 4 different lines in the chart).
This is the dummy pbix: https://mega.nz/#!fMNkEZiR!BYWSyj6WG3eRqyrAHEDr-sDaBFcd4LXAYqlvVCQTtn0
I'd be very grateful if someone could help me : ) Have a nice day.
is this what you are looking for?
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.
Yes, something like that. Could you share the solution please? : )
Go to query editor, select date column, right click and choose "Unpivot other columns"
you will get two more columns attribute and value, change column name attribute to "Zone"
Add line visual, date on axis, value column on value and zone on legend. that will do it.
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.
But that is not the moving average, that is just plotting the values, right?
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 |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |