Forum Discussion

mafioso's avatar
mafioso
Icon for Helper II rankHelper II
8 years ago
Solved

Automatically 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....
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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's avatar
mafioso
Icon for Helper II rankHelper II
8 years ago

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's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

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's avatar
    mafioso
    Icon for Helper II rankHelper II
    8 years ago

    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's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      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's avatar
        mafioso
        Icon for Helper II rankHelper II
        8 years ago

        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.