Forum Discussion
Helper IIAutomatically set values of slicer dependent on user selection
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
Helper IIHi,
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?
Microsoft EmployeeHi 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.