Forum Discussion
Animation Filter that Shows Cumulative Data Over Time
I am working on a map that shows sales per zip code across the USA. Currently I am using the map vizulatization and the play axis visualization. I have also tried using the drilldown player. I want to click play and see how sales accumulate across the map over time. Instead, when the Play Axis runs, it shows me one day, then the next, and the next; but it does not retain the data from the previous days.
Essentially my issue is that these animations are acting like a single slect filter; selecting one day, then deselecting that day and moving to the next day. I want a multi select filter animation, it selects the first day, then adds the second days data, and the thrids, etc.
Any ideas how to achieve this?
I want an animated version of what i am doing below:
Instead today when I run Play Axis I get this:
10 Replies
Anonymous you need to create cummulative sales measure and use that for bubble then it will work as expected. Try following for cummulative sales
Running Sales = CALCULATE( SUM( Table[Sales] ), FILTER( ALL( Table ), Table[Date] <= MAX( Table[Date] ) ) )
Thanks for the reply!
I tried entering your measure, and the measure worked but it did not produce the effect desired. Here is the measure I entered:
"Running Sales = CALCULATE(sum(Sales[Revenue]),filter(all(Sales),Sales[Date]<=max(Sales[Date])))"
And the behavior is still showing one day, then jump to the next, and the next; as seen below:
I believe it may have to due with how my data is set-up. I have one sales table with Date, Model, Zip Code and Revenue. On the Jan 1 there is a sale in zip code 43064. But on Jan 2 there is no sale in zip 43064. Therefore, when the animation is on Jan 2, the bubble over zip 43064 disappears. I want the data from Jan 1 to remain on the map, and add the data from Jan 2 to it when the animation runs.
Adding a cumulative sales meausre would only work if there were record for every zip code, every day, which there is not.
I am thinking about that correctly? I am still very new to PowerBI so feel free to tell me if I am totally off base.
Anonymous are you ok to share your pbix file using onedrive/google drive, remove sensitive informaiton
Hi,
Did you get a solution for this? I am facing the same challenge, kindly help.
upvote +1. any solutions?
I had to import an excel file with a table of cumulative dates, like this one
It works perfectly
