The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone,
I have a slicer/dropdown list question. As you know, an usual dropdown list in Power BI looks roughly like this:
However, I really hope to create a dropdown list that has subcategories like current and past programs, and within those subcategories, there are different program names and multiple selection are allowed across subcategories. Mockup attached below:
Is this doable? I don't know if this is wishful thinking but would greatly apprecaite any tips or ideas if there is a way to do so!
Thank you very much in advnace.
Best regards,
Emily
Solved! Go to Solution.
@emilyhch Yes, just create an additional column with your categories. Then you add both columns into the slicer in an ad-hoc hierarchy.
@emilyhch Yes, just create an additional column with your categories. Then you add both columns into the slicer in an ad-hoc hierarchy.