Forum Discussion

mmar's avatar
mmar
Regular Visitor
6 years ago
Solved

Create a filter for multiple data sources

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?

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

1 Reply

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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