Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

 

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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    this is a basic function in excel - they should really support this somehow.