Forum Discussion
Helper IIAutomatically set values of slicer dependent on user selection
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?
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
6 Replies
- TomMartens
Super User
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
mafiosoI 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
