Forum Discussion
Animation Filter that Shows Cumulative Data Over Time
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
- Anonymous7 years agoNot applicable
Yep, here is a link. Let me know if you have any issues downlaoding it. I removed the "Model" column for scrubbing reasons. Essentially each row is a record of a sale of a model in a certain zip code and the revenue from that sale.
https://drive.google.com/open?id=1PUQpCxBkHiDP-8twj6kaISpCB7gMnZo1
Thanks again.
- parry2k7 years ago
Super User
Anonymous Hey sorry for late reply I think I got the idea on how to resolve it, I need to do some data transformation in Power Query, could you please share the excel file you used in this report so that I can do Power Query steps. Cheers!!
- pablozunigag3 years agoNew Member
Do you have any solution for this? Thanks