On Multiple selection in slicer, the matrix table output behaves abnormally

[sagarsahoo_123]

Hi Team,

I need your support to resolve one issue which i am facing.

Please note that i am using Measures in slicer by the help of below link provided in this forum.

https://hclo365-my.sharepoint.com/:u:/g/personal/sagarhemaranjan_s_hcl_com/EbmILJ0E5nVBomwESq3-bbcBJ...

The result which iwas looking, found here but got one problem. Whenever in slicer, i am making single selection it is working absolutely fine, but i tried with multiple selection, then the result in the table completely gone wrong.

For example:-

If you look at the below image, where "Input Range" slicer which is expanded having different categories like <4hrs,4 to <6hrs and so on basis of the total of WorkTime shown at last of the table.

On the single selection it is showing perfectly fine like below image.

Here i have selected <4hrs and it is showing the exact numbers highlighted above in that range, but when i did multiple selection like <4hrs and 4 to <6hrs, then it shows everything ,but it should show only value <6hrs,not all.

In the above my selection is <4 and 4 to <6hrs, but it shows even all numbers >18hrs as well highlighted above.

How to fix to show as correctly when multiple selection is done in the Slicer using measures!

Need your support to fix this. Any help will be highly appreciated.

Regards,

Sagar

[v-xiaotang]

Hi @sagarsahoo_123 

Not able to access this file, when I open it it reminds me that I have to log in to get the file. Please try to re-share.

Besides, the part that should be checked is whether the function's filter() will pass in all the content selected by the slicer ethics

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.

[sagarsahoo_123]

Hi @v-xiaotang ,

Please check if the below link opens for you. I refered that and used the measure as slicer.

Solved: How to use a measure as slicer? - Microsoft Power BI Community

But slicer was ready but working fine with sinlge selection in slicer. It does not give desired result for multiple selection in slicer.

Regards,

Sagar

[sagarsahoo_123]

Hi @v-xiaotang ,

Attaching the sample set for your better reference. In the "Details" page in the "Input Range" slicer , if we select multiple values, then it behaves all value. With single selection it is working fine.

https://1drv.ms/u/s!AqNLfMSghxwyhgVaPes9qbktkg34?e=cfhyqs

[sagarsahoo_123]

Hi @v-xiaotang ,

Hope you are able to download the sample file which i have sahred in the OneDrive. Please let me know if you have got some solution to this problem.

Regards,

Sagar

[sagarsahoo_123]

Hi Team,

Any help on the above issue is highly appriciated.

Regards,

Sagar