Dynamic M query parameters doesn't work in analyze in excel option

Dynamic M query filtering doesn't work in analyze in excel option. I tried the filter fields in the filter area of the MS Excel pivot table but it doesn't trigger query with the selected value but in...