Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I've been trying to create a customized dropdown slicer for a filled map containing three options: State, City, Postal Code. The goal is to toggle between these three, aka create a drillthrough but using a dropdown slicer instead.
I've been trying out various DAX functions but was not able to make it work with maps since Power BI requires a geospatial field for a map. Any suggestions/tips as to how can I approach this?
In the data, I have the following location hierarchy:
State | City | Postal Code |
Pennsylvania | Philadelphia | 19140 |
Pennsylvania | Philadelphia | 19140 |
Texas | Houston | 77095 |
Texas | Richardson | 75080 |
Texas | Richardson | 75080 |
Texas | Houston | 77041 |
Thank you!
Solved! Go to Solution.
This works perfectly!! Thank you so much!
is this you are expecting???
Not exactly. Instead of a hierarchical slicer that contains all of the states, cities, and postal codes in it, I need a slicer that only has three options "State", "City", and "Postal Code". In other words, I need it to contain only these three options regardless of how many states/cities/postal the data contains.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |