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