Forum Discussion
Table relationship
Hi, I have three tables: Date, Region, and Sales.
The Region table is a table in which the country's corporations change by year.
For example, in 2022, the corporation of country A is A, and in 2021, it is B.
I want the corresponding year's Region/Subsidiary/Country to be shown when selecting the date Slicer, and the corresponding Sales value to be shown.
How can we solve this problem?
Hi ericjo ,
Could you please tell me that if your problem has been solved?
If not, is there any relationship between your three tables? If you create a relationship, when the fields in one table are filtered, the fields of the other table are dynamically filtered.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
If you can, please provide some sample data, along with the expected result. Please be careful to protect your privacy.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
ericjo , if they are from same table, they should filter automatically.
else you can get measure from the common fact and use that as a visual level filter of other slicers
refer: https://www.youtube.com/watch?v=cyOquvfhzNM
Another way, depending of the data
How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8
Hi ericjo ,
Could you please tell me that if your problem has been solved?
If not, is there any relationship between your three tables? If you create a relationship, when the fields in one table are filtered, the fields of the other table are dynamically filtered.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
If you can, please provide some sample data, along with the expected result. Please be careful to protect your privacy.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
