Forum Discussion
jcozens
6 years agoRegular Visitor
Create a rolling measure which rebases graphically using the date filters
Hi,
I'm trying to build a line graph which tracks the accumulated growth of sales over any date period selected by the date filters.
I've managed to get the running total measure that allows a daily growth figure which I can plot onto a line graph. However when I change the date range on the filter, the values on the graph (understandably) do not start at 0 but at the accumulated number at that date.
How do I get the running total measure to start calculating from the date selected in the page filters?
Hi jcozens ,
You could create a measure to get the dynamic result.
Here is my test file for your reference.
1 Reply
- v-eachen-msftCommunity Support
Hi jcozens ,
You could create a measure to get the dynamic result.
Here is my test file for your reference.