measure average - filter

[Anonymous]

Hey everyone, I have a problem I wanted to ask about! 🙂
Below I have two charts (blue and green), when I click on the date on the green one (right), my blue chart looks like the one below (left):

I would like to get the below image when I click on the date on the green chart:

What should I change in the average measure? I would like the average curve to not go down but stay in the background at the level it actually is. On the X axis is Calendar[Date].

The measure for average looks like this:

avg =

DIVIDE ( [Last 7 days blue]; 7 )

Thank you in advance! 🙂

[v-jayw-msft]

Hi @Anonymous ,

Looks like the data was filtered after clicking the date in right chart. You will need to create an independent date table and use it in the Chart so that the data won't be filteredby the date.

Best Regards,

Jay

[Anonymous]

Hi @v-jayw-msft 

I don't really understand? I would like both charts to be filtered by date and go to a lower level of the hierarchy which is the hour. I would like the drill down to hours to work on two charts at once, when I click on one of them, so that on two charts the same date (previously selected on one of them) goes down to hours.