Power BI
NewConnect fields in tables as the same so filters work over multiple tabels, like for example month or date etc.
Michiel on 28 Sep 2015 14:21:21
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.
- Comments (3)
RE: Connect fields in tables as the same so filters work over multiple tabels, like for example month or date etc.
'@Daniel, this only works if one of the columns is unique. This isn't the case in my situation :(
RE: Connect fields in tables as the same so filters work over multiple tabels, like for example month or date etc.
How to achieve this in Power BI Embedded i.e. Web-based one?
Please advise!
RE: Connect fields in tables as the same so filters work over multiple tabels, like for example month or date etc.
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.