How to display rows in my table which don't get mapped to the map visual?

[afaro]

I am using a map visual by country and I want to see which countries are not getting mapped to the map visual as a table. 

[Anonymous]

Hi @afaro,

You can create a custom table with countries and labels and link to the raw table.

Then you can use the label field on the map visual filters to control displayed countries and create a table visual with table records to show the invert values.

Regards,

Xiaxin Sheng

[afaro]

Where can I get the data for the custom table? What data is used in Power BI for country and label names? 

[Anonymous · Accepted solution]

HI @afaro,

You can use dax expression to extract the field value from raw table records to create a new calculated table or import a dictionary table. The label mean the filter flag based on your conditions or dictionary mapping.

If you want to make these affects dynamic, you can use this new table field to create a slicer, then create a measure to get the selection from slicer and compare with raw table field values to return flag. (this flag measure is used on the 'visual level filter' of map visual and table visual, you can use flag to control and display different result on these two visuals)

Regards,

Xiaoxin Sheng