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,
I have 2 fields, POL (port of loading) and POD(pod of discharge). These are 5 letter codes that shows both country and city. I also have a master list of all portcodes with seperate columns for country and city.
I initially created a relationship between both sheets selecting POD and the portcode in the master list. When I select country in the charts, it shows the POD countries. This was what I wanted.
however, when I decided to include POL into my visualisations and wanted to show the countries of the POL, it was unable to link the POL countries when I select country from the master list in the visualisation. It still shows the POD countries.
Can someone advise on the steps I will need to take?
Solved! Go to Solution.
A coiuple of ways, you could have multiple relationships and write DAX with USERELATIONSHIP. But this is quite complicated.
For the descriptopn, it sounds like you could create a star schema with three dimensions:
Country/City,
Product (with a unique product id to link to pod and pol)
Then two fact tables, with
POD
POL
Check out the documentation:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!
Stay up to date on
Read my blogs on
Remember to spread knowledge in the community when you can!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
A coiuple of ways, you could have multiple relationships and write DAX with USERELATIONSHIP. But this is quite complicated.
For the descriptopn, it sounds like you could create a star schema with three dimensions:
Country/City,
Product (with a unique product id to link to pod and pol)
Then two fact tables, with
POD
POL
Check out the documentation:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!
Stay up to date on
Read my blogs on
Remember to spread knowledge in the community when you can!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |