The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |