Forum Discussion

JD0963's avatar
JD0963
Helper I
8 years ago

Filter unrelated data source?

Hi, hopefully someone can help. Please see the below examples. I have a main table input which is a flat table within SQL server. I also need to somehow link an additional data source within PowerBI based on username and date.  The unrelated table below is the one I need to link to.

 

Ideally I would be able to select username and date range on the main query, and this would filter the unrelated table as well to show data for that user, in that date range. Also, if I select multiple users on the main table, the same selected uses would filter through on the unrelated table.

 

Is this doable?

 

Thanks :)

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi JD0963,

     

    Why don't you establish a one to many relationship between these two tables based on field [Username]. As it is not possible to enable cross filter between two unrelated tables.

     

    Regards,

    Yuliana Gu