Excluding data from visual based on date range

[pb123]

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 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, but excluding the periods filtered out.

I know that if I simplify this into one measure which is not filtered by year I can get something like the below, but then from what I understand I am then not able to create an average line of all the years to display on the same chart.

Does anyone know how I can exclude those those static values in the fisrt picture (i.e. treat them as blank/null) so that I can achieve the result in the second picture AND be able to show an average line on top of that?

Hope is clear, many thanks!

[v-xiaotang]

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.