Forum Discussion
pb123
4 years agoFrequent Visitor
Excluding data from visual based on date range
Hello, I have a some measuyres which calculates the moving average of a sum of values in my table each day in a specified year (related to a date table), but when I move the date filter, I get a ...
v-xiaotang
4 years agoCommunity Support
Hi pb123
Thanks for reaching out to us.
>> but when I move the date filter, I get a static line for values outside of my date range....My goal here is to be able to have another measure which is the average on each day for all the years selected,.....
How did you design it? Could you share the sample file or a screenshot of this page, including which fields are placed in your line chart & which fields are placed in your slicer.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.