Forum Discussion
Empty table visual when nothing is selected on Map Visual
Hi,
Unfortunate about the file.
But about your earlier point if i understand you correctly, first you pick a country by using the slicer. The map will be filtered but the table should remain empty, but when you pick a city on the map than the table should show all information related to that city/location.
If that's the case, my calculation i poster earlier should work.
Just use the same location column that you use in the map and use in the the calculation. Then you just need to format the slicer so it wont filter the table.
You can do this by selecting the slicer/filter and then click on format in the toolbar -> edit interaction and choose none on the table.
Hi Gordonlilj
Many thanks for your reply.
Unfortunately did not work for me. Maybe the below diagram will make sense to you.
Here we have a filter, called Country, when selected, Map will show all the locations in that country, but table visual will remain empty. But when we click on any city/location in the Map, Table will show an entry or data related to that location. If there is no location selected/clicked on the map, Table visual will be empty.
Please let me know if we can achieve this functionality.
Thanks.
Solution SageHi,
This should achievable but could you provide some sample data in order to give a solution that works for you
Hi Gordonlilj
Thanks for looking into it.
I am trying to share some data, but did not get the option to upload the file :-(
- Gordonlilj
Hi,
Unfortunate about the file.
But about your earlier point if i understand you correctly, first you pick a country by using the slicer. The map will be filtered but the table should remain empty, but when you pick a city on the map than the table should show all information related to that city/location.
If that's the case, my calculation i poster earlier should work.
Just use the same location column that you use in the map and use in the the calculation. Then you just need to format the slicer so it wont filter the table.
You can do this by selecting the slicer/filter and then click on format in the toolbar -> edit interaction and choose none on the table.