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
