Power BI Slicer Issue with SELECT ALL & SINGLE Value selection

[Anonymous]

Hello All,

We have a requirement where User should be able to do only two things in Dropdown Slicer

1) SELECT ALL -- To see Overall Data

2) Only Single Value -- To see indiviual data

3) User should not be able to select multiple value except SELECT ALL

4) User should not be able to select multiple value with CTRL + Click also. 

Thanks,

PBI V2

[Anonymous · Accepted solution]

Hi @Anonymous 

You can refer to the following sample

Sample slicer table 

Slicer_cate

Slicer_data 

Data table

Then create the following measures

Measure = IF(SELECTEDVALUE('Slicer_cate'[Column1])="Other",1,0)

Put the measure to the data slicer visual filter 

Then create another measure

Measure 2 = IF(OR(SELECTEDVALUE('Slicer_cate'[Column1])="ALL",ISFILTERED('Slicer_cate'[Column1])=FALSE()),CALCULATE(SUM('Data'[Column2])),IF(SELECTEDVALUE('Slicer_cate'[Column1])="Other",CALCULATE(SUM('Data'[Column2]),FILTER('Data',[Column1] in VALUES('Slicer_data'[Column1])))))

Then put the measure to the table visual

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Idrissshatila Thanks for your response. It looks like it is not possible in Power BI visual. Just looking for any solution that can be build at data model level where we can add one more value as "Overall" in slicer. When user select "Overall" slicer should display data for everything and when user select a single value then report should display data for only that selection.

Let us know if any such possibility

Thanks,

PBI V2

[Idrissshatila]

Hello @Anonymous ,

This is not acheivable since it's in the function of the slicer, it's either you can select all and have the option to select multiple values as well or single select or select with Ctrl.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin