Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Maybe look at adding a HASONEFILTER to your measure?
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
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
Спасибо за ответ
Maybe look at adding a HASONEFILTER to your measure?
Thanks for the answer
Hi @Arsenal,
You're welcome, please mark the helpful reply as answer, so more people will find the solution clearly.
Thanks,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |