Dynamically select what the (multiple) filters/slicers will be

[Anonymous]

Hey there,

I am working on a report in which I want to reveal some interesting relationships in our dataset.

Let's say I have this table:

   A  B  C  D (<attributes)

1 (values in table)

2 

3

4(< ID)

Which I have also unpivoted and connected both ways:

ID, Attribute, Value

1 A value

1 B value

1 C value

1 D ''

2 A ''

2 B etc

2 C

2 D

3 A

3 B

3 C

3 D

4 A

4 B

4 C

4 D

And now I want to have let's say 3 slicers:

[Attribute] [values] [Attribute] [values] [Attribute] [values]

I want to be able to select an attribute, and in the slicer next to it, I want to be able to select one of the values.

Next to that I want to be able to select another attribute, and again select one of the values.

However, Whenever I selected the first Attribute+Value, all other Attribute+Value slicers (obviously) are already filtered.

I tried to use delete the relationship, but obviously we are dealing here with the same table, so that doesn't work.

Any ideas how to select multiple slicers WITH the slicers being dynamically changed to whatever attribute you want?

Kind regards,

Igor

[Anonymous]

Anyone?

[Anonymous]

No one

[v-frfei-msft]

Hi @Anonymous,

Try to edit the option. For more details, please check the online document.

Regards,

Frank

[Anonymous]

I also attached a link to the testfile:

https://1drv.ms/u/s!ApYezvnm5pOshWQW4TGubgDqON7Y

[Anonymous]

With the dataset below I know I could use create 4 slicers 'Color', 'Rating', 'Size' and 'Type' and it still fits on the screen. But with the real dataset I'm working with I have between 100 to 110 filters, and everytime you want to filter on totally different columns.

Maybe I need to change the datamodel somehow, 'dynamically' cut the columns in 100 to 110 different tables, but I hope not. Since that would raise more questions.

So the story goes as the following:

Within the red boxes I want to select the filter I want to use, so you can select the value in the blue boxes.However, as soon as I select 'Type', it already shows 0 results.The datasetThe relationship works both ways

[Leon1213]

Hi Igor,

When you select a slicer, you can see 2 more options on the Top Bar where the Home menu is present.

Click on "Format" and select "Edit Interactions". Now you can edit which slicer should filter which slicers and you can also do the same for visuals.

Thanks,

Leon  

[Anonymous]

Unfortunately this doesn't work, since 'I don't know' or let's say I want to be able to choose the filters in the front-end.

I will create a small dataset and some screenshots to show it more clearly what I mean.

The story says it all, but I think it is too difficult to comprehend easily, sorry for that.

Kind regards,

Igor