Optimization of work slicer

[Arsenal]

Hi. Tell me how you can solve the problem.

There is a monthly slicer for the average indicator chart, 
if you accidentally press a month twice, the slicer switches to "all" and sums all the averages. 
As a result, data on the resulting average indicators are distorted. 
Can I somehow configure the slicer so that if I accidentally press it twice for any month,
 it stays on the same month?

[Greg_Deckler · Accepted solution]

Maybe look at adding a HASONEFILTER to your measure?

[v-huizhn-msft · Accepted solution]

Hi @Arsenal,

It means you don't select any month in the slicer if you click a month twice accidentally. So it shows "all" and sums all the averages. Until now, it's impossible to stay results on the same month when you when you press one month twice. 

Best Regards,
Angelia

[Arsenal]

Спасибо за ответ

[Greg_Deckler · Accepted solution]

Maybe look at adding a HASONEFILTER to your measure?

[Arsenal]

Thanks for the answer

[v-huizhn-msft]

Hi @Arsenal,

You're welcome, please mark the helpful reply as answer, so more people will find the solution clearly.

Thanks,
Angelia