Automatically set values of slicer dependent on user selection

[mafioso]

Is it possible to select values of a slicer automatically?

In my case, I have 3 options: car, train and plane. Lets assume that I choose car.

Then I have 5 choices: bmw, audi, volvo, toyota and vw. I want audi and vw to be selected automatically after pressing the car button.

Is that possible or not?

[TomMartens]

Hey,

I'm not totally sure if I understand what you mean by "... pressing the car button", but I guess you can give the booksmark feature a try: https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Hopefully this gets you started

Regards

Tom

[mafioso]

I have currently 2 slicers. As I mentioned, one contains car, plane and train. If I choose car in the slicer then the values should be selected. 

[TomMartens]

Hey,

basically you can achieve this if you're tables are properly related.

Due to the fact that you just want to select some of the car brands selected, I guess you have to come up with a solution that is based on bookmarks.

Please consider to prepare a pbix file that contains some sample data, upload the file to onedrive or dropbox and share the link.

Regards

Tom

[mafioso]

Hi,

is it possible to automatically select all values of a slicer dependent on another slicer?

For instance if I have these lines:

car | Audi

car | BMW

car | Toyota

animal | cow

animal | dog

phone | Nokia

phone | Samsung

Lets assume I'll choose car in my first slicer, then all animals and phones disappear (because of my relation in the model). Now in the second slicer, only Audi, BMW and Toyota are shown. Is it possible to select all of them automatically after selecting car?

[v-yulgu-msft · Accepted solution]

Hi @mafioso,

Since two fields are from the same table, the two slicers are related. Once you selected any item in first slicer, the second one will only show available selections which are matching with the selected value in first slicer. In your example, selecting "car" in first slicer will filter the second slicer that it only lists Audi, BMW and Toyota. But, automatically selected is not supported in desktop. You will see Audi, BMW and Toyota shown in second slicer without being selcted. However, by default, if there isn't any value selected in slicer, the related visual will consider this behavior the same as "select all" and display all data records in visual.

Best regards,

Yuliana Gu

[mafioso]

@v-yulgu-msft thank you! Didn't know that they are all selected by default. Isn't really the way I first wanted to fix it but still a working solution.