Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Created a nested filter

I have a slicer where I select a product brand and I want the category it's in to show automatically but I haven't been able to figure it out.  Both pieces of data are in the same table.     testM...
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

Stachu's avatar
Stachu
Community Champion
7 years ago

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 suggested

Anonymous's avatar
Anonymous
Not applicable
7 years ago

No, 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    none of these suggestions work I'm afraid.  If anyone wants the file by PM let me know and you will instantly see what I mean.