Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lcfaria
Helper II
Helper II

Facts separated by semicolons & Visual Map not filtering other slicers

Hi everyone,

 

I have a table with columns that bring information about each member, with the following structure:

lcfaria_1-1674683943194.png

 

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.

lcfaria_2-1674683976521.png

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:

lcfaria_3-1674684171337.png

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!

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.