Created a nested filter

[Anonymous]

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.  

testMeasure = LOOKUPVALUE(LinkToBrand[Product Category (Dynamic) L2],LinkToBrand[Brand],SELECTEDVALUE(LinkToBrand[Brand]))

This formula works but I obviously can't use this in a slicer.  Any ideas?  

[v-yulgu-msft]

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

[Anonymous]

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 · Accepted solution]

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]

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

[Anonymous]

[Stachu]

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]

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]

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. 

[Greg_Deckler]

You should just have to get the MAX of the category. If you are using a slicer to filter to a particular product brand then there should be only 1 category so any aggregation that returns a text value (like MAX) should work.

Then just display that measure in a card visualization.

[Anonymous]

But the second slicer is required as it dissects a table. I can already get a card visualization using my formula. What I need is the user selects the brand and then the second slicer auto populates. This then still works on the tables. A card visualization cannot be used to slice a table as I understand. If it helps I can post image tomorrow from work. But this suggestion doesn't work I'm afraid.