Connect fields in tables as the same so filters work over multiple tabels, like for example month or date etc.

[michielmoes]

If I have multiple tables with information, with in both tables a column with the month or date. When I create one report with charts from both data sources. And I click on a month in a chart based on dataset 1, the chart from dataset 2 is not filtered on that month. So I would like to be able to define both columns as the same time of infromation.

[djnww]

This can already be done. You need to connect the similar fields, in this case the date fields, in the relationship management tool in the Desktop app.

[meghajn86]

How to achieve this in Power BI Embedded i.e. Web-based one? Please advise!

[rywinter]

'@Daniel, this only works if one of the columns is unique. This isn't the case in my situation 😞