Table relationship

[ericjo]

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?

[v-stephen-msft · Accepted solution]

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.

[amitchandak]

@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