slicer with only country names present in a column/table

[rssilvaba]

Hi All, New to PowerBI.

One of the columns I have is the code for the country (206,250 etc) and I am trying to create a slicer that shows only the country names available within the data table.

I am able to create a distinc table which in my case is a column for France and Germany codes. I have another table with the code and it's repective name.

Altough I could not find a way to create a new table only for these two values dinamically.

Any ideas?
Thanks!

[az38]

Hi @rssilvaba 

Its unclear from your task description, but maybe it will be enough just to create relationships between tables?

you could provide your input data and desired output in order to help you more quality

do not hesitate to give a kudo to useful posts and mark solutions as solution

[rssilvaba · Accepted solution]

Hi, The relationship only is not enouh the slicer shows all countries.

I figured it out by adding the following column:

CountryName = RELATED('Country Code'[Country])