Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have a table with columns that bring information about each member, with the following structure:
I need to put 4 slicers on the page (unit, type, style, location) to be able to apply filters to my data. What I did was create 4 references to my main table in Power Query (one for each column) and then I unpivoted the columns and created a relationship from both directions to be able to use that within slicers.
The thing is, I'm pretty sure this isn't the best way to go about this, and I'd like your input on how I can best structure this, please.
Another thing is, I added a map visual to my page, however, when I select some country from the map, my slicers are not being filtered. For example, I the picture below I have Canada selected from map visual, but the slicer still keep showing Africa and Asia:
Is there any way to solve this?
I am attaching a sample file with the data.
Link: https://1drv.ms/u/s!At5JlMR_naI1gf5F2JR-fuy47e9i5Q?e=FClOSd
Thank you very much!