Table is not filtering another table as per expectation

[Anonymous]

Hi Guys, Hope you all are doing good. I have been facing this issue , I have two tables in power Bi report . I am trying to filter history table with the recent table. But its not giving me the exact result I want. I have tried all the  filtering single/both but not getting exact result. Thanks In Advance. PS- I am using live query here.Relation

Once clicked on recent table it should all records of that in history tableBut after clicking I am getting this... what could be the reason. I need all the records of that bus

[saivivekv25]

Hi ,

Did you find the solution for this?

[v-xicai]

Hi @Anonymous ,

Which field did the relationship between the table Recent and History create on, BUS_ID or something others? There may be some blank spaces in the related key.

Please keep the Cross filter direction of the relationship from Single to Both, which will take the two tables treated as a single table. You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

Or could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Amy,

Relationship is on BUS_ID  & there is no blank in it.
I tried cross filter direction to both but the things are not working out.
The desired output I am expecting is the history table should show all the records of what I select in recent table.
eg. if I select Bus Rto No- MH12AB005 from Recent table then history table should show all the records of MH12AB005.
Regarding data & pbix file I w'ont be able to share it.

Thanks.
Regards,
Abhijit K