Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello!
I have an 7 days rolling average of brand awareness shown on the line chart. The formula for 7-days rolling average is this:
And when it's applied, it breakes the linechart, and shows the results only for those day, when I had the data, so, when I put just rolling avg in the line chart, it shows all the dates, when TOP, only on those I had the data.
Could you help, guys? I've struggling with this for a long time already, idk even what's wrong, maybe you have any ideas. If you need more details, I could provide more, but not the real data, as it's confidential.
@Anonymous
Could you please share the result that your are getting currently with your measures.
and please share your expected result with dummy data. so it would be helpful to understand more.
So, let's take a small period, here is where I choose "All" in my switch slicer, this All is assigned a first formula I shared in the main message.
As you can see, on the axis it shows all the dates, however, in some days during this period I didn't have data, however, I my formula calculates rolling average taking -7 calendar days, it still have some results for those date where I didn't have data.
When I selecting Top 5(second formula from the main message), it works ok, return only 5 top values based on the rolling avg measure, howerer it doesn't show the results for those days I don't have the data, but it use the same measure, just apply topn function.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |