Forum Discussion
Created a nested filter
Hi Anonymous,
No. Slicer in Power BI doesn't support to automatically select any item from the drop down list, even though there is only one item. Users have to choose values manually.
Regards,
Yuliana Gu
Hi Anonymous,
Since both pieces of data are in the same table, there is no need to create any measure to return corresponding category values. Based on Visualization Interactions, when you select an item in first slicer, the second one will be automatically filtered, returning corresponding categories.
Best regards,
Yuliana Gu
Maybe this image will help - if I select the top filter it will not automatically select the next filter - it still has to be clicked (it will stay on 'All' - when I click it on it, yes there is only one option but the point is having to click. I just want it to auto select...
even though the slicer says All in that the category is actully crossfiltered to Cheese. Why do you also need explicit filter on that field?
if it just about clarity for the user then you could create a card displaying currently selected categories etc. with a measure, similar to what Greg_Deckler suggestedNo, because unless the user clicks on cheese then the graphs below and tables don't display correctly. They either don't show or show whatever category the previous brand was.
Hi Anonymous,
No. Slicer in Power BI doesn't support to automatically select any item from the drop down list, even though there is only one item. Users have to choose values manually.
Regards,
Yuliana Gu
this is a basic function in excel - they should really support this somehow.
