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.
I am looking for some ideas to use a joined column as a master filter or slicer to view my data, have a data set as below;
Relese Country | Units Sold | Hold Country | Units Recieved |
Netherlands | 0 | Germany | 1 |
Germany | 0 | United Kingdom | 0 |
Netherlands | 1 | Switzerland | 0 |
Switzerland | 1 | India | 0 |
So i want to use a country filter and see the results like below ( for eg; if i select germany in the filter).
Country = Germany
Units Sold | 0 | Units Recieved | 1 |
Country = Switerland
Units Sold | 1 | Units Recieved | 0 |
The only id thats common is country name, but one country will be missing for units recieved, so will have to do full join.
Any ideas? Thanks
Solved! Go to Solution.
@JCK2 , Create a country table
Country =
distinct(union(all(Table[Relese Country]),all(Table[Hold Country])))
Join both country column with that one active and one inactive or keep both inactive. And Use userelation to activate the join as per need.
Refer to this example for userelation : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
@JCK2 , Create a country table
Country =
distinct(union(all(Table[Relese Country]),all(Table[Hold Country])))
Join both country column with that one active and one inactive or keep both inactive. And Use userelation to activate the join as per need.
Refer to this example for userelation : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Looks intresting! let me give it a try and keep you posted! Thanks Amit!
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 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |