Forum Discussion

phockey24's avatar
phockey24
Frequent Visitor
7 years ago

Filtering Visualization Dates with a Running Total

I'm looking to display a cost variance between estimated and projected (anticipated) costs.  From month to month, we update our projected cost to forecast any issues.  I need a visual that shows me h...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi phockey24 ,

Can you please share more details? Do you want to display only the values of last periods? If so, you can change the date range in the measure. If you want to show values when you filter the date, maybe you could a new date table as a slicer  to filter it . Or you can post some sample data and the expected output. Then we can help you as soon as possible.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

phockey24's avatar
phockey24
Frequent Visitor
7 years ago

I apologize, I'm really not sure how I can make my explanation better.  I can't exactly share my model (as it is massive).  I'd be curious on how to apply a date filter to that formula - but for now we've determined that this visualization will not help us.

 

Thanks for your time.