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.
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!
Solved! Go to Solution.
Hi, The relationship only is not enouh the slicer shows all countries.
I figured it out by adding the following column:
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
Hi, The relationship only is not enouh the slicer shows all countries.
I figured it out by adding the following column:
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |