How to force the selection of a Slicer and only let the user select what is not forced

[Bastienlin_]

Hello,

I'd like to know if you know of a way to force the selection of a filter, while leaving the freedom to select another element.

Here's an example to illustrate my point:

I'd like to be able to force the selection of entities A and B in all the visuals on my page, while leaving the user free to select any entity C, D, E etc..

The aim is to leave the user only the option of selecting entities other than A and B, and thus hide them from the Slicer.

The image below shows an example of what the user should see if he selects entity C.

Note that we have a lot of different entities

Thank you for your help !

[v-yangliu-msft · Accepted solution]

Hi  @Bastienlin_ ,

I created some data:

Here are the steps you can follow：

1. Create calculated table -- slicer.

Table 2 =
DISTINCT('Table'[entity])

2. Create measure.

Flag =
var _select=SELECTCOLUMNS('Table 2',"select",'Table 2'[entity])
return
IF(
    MAX('Table'[entity]) in _select || MAX('Table'[entity]) in {"A","B"},1,0)

3. Place [FLag] in each visual filter that needs to be forced to display.

4. Result:

Best Regards,

Liu Yang

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