Hi there,
I have a dataset with Open End answers that have been codified the codes translate into fields in power BI, but I would like to have a drop-down list in the dashboard with all the codes to be able to select and filter per code.
Is that possible?
Thanks,
Sara
hi, @Anonymous
After my research, I'm afraid it couldn't achieve that have a slicer with three columns as you want on your original data structure in Power BI for now. You may try to use three slicers like this:
Also, if you want them in one slicer, you may try to use this way:
In Edit Queries, select accessibility, booking, experience then click Transform-> Unpivot columns
then drag field Attribute and Values into slicer like this
By the way, This method will turn your this data table three times as large.
and here is demo pbix, please try it.
Best Regards,
Lin
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
