Create a filter for multiple data sources

[mmar]

Hi,

I need to create a report as in the attached image. The upper part (ingredients) works with data from a Database source.

The part below with a line chart should work with data from an Historian.

I would create a Stored Procedure in the DB to retrieve data from the Historian.

In both cases I should filter the data using the order-number. How can I filter both sources using only one filter?

Can I use the order-number chosen by the filter tab in Power BI as input for a stored procedure parameter?

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i create a sample to test:

In order to filter both two tables by one filter, please try to create a calculated table first:

Slicer Table = CROSSJOIN(DISTINCT('Table 1'[OrderID]),DISTINCT('Table 2'[Number]))

Then add an column to this table:

Slicer Column = 'Slicer Table'[OrderID]&"-"&'Slicer Table'[Number]

Create one-to-many relationships among them:

When you select one value in this [Slicer Column], it will filter both two tables:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi