Connect fields in tables as the same so filters work over multiple tabels, like for example month or date etc.
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.
@Daniel, this only works if one of the columns is unique. This isn't the case in my situation :(
How to achieve this in Power BI Embedded i.e. Web-based one?
Daniel (Australia) commented
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.