Forum Discussion
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-msftMicrosoft 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