Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to reduce the number of items listed on a slicer. The slicer is listing all 210 countries in the world.
The slicer doesn't offer type-in functionality, and I would rather avoid the consumers of the report to have to scroll this number of items for their multiple selection choices. The selections will be then used to make comparison against the drillthrough single country selected in the previous page.
I thought to use a fill map from where the user would click the countries, and have the slicer presenting only the country selected.
Assume I have a table 'Comparing Countries'[country code] I use to fill the map, my question is: how can I make the slicer only present the countries selected?
When I try to create a table based on values('Comparing Countries'[country code]), it somehow lists all 210 countries regardless the selection. Although, if I use that expression in a measures, like countrows(values('Comparing Countries'[country code]) it returns the true number of countries being selected, as I would expect.
So, I conclude that creating tables won't take in account context, even if I use allselected. So is there a way I could pass to a slicer a virtual table?
I hope the problem is not too confusing. Any help is immensily valuable.
Thank you,
/Flavio
Solved! Go to Solution.
Hi @flaviotti,
Have you tried the chiclet slicer?
it allows filter when you select from the map.
Hope this helps!
Hi @flaviotti,
Have you tried the chiclet slicer?
it allows filter when you select from the map.
Hope this helps!
Hi @mussaenda
Fantastic! It looks this will solve my need!
Thank you so much for the fast and valuable answer.
Regards,
/Flavio
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |