Filters are not working for relationship values

[Anonymous]

Hi All,

I  have created a realtionship for Created and Planned date to calender Date in my report. Currently My filters are working for only based on Created Date selection and not for Planned Date. How to have filters values for both the Created and Planned Date selection. 

Please assist

[v-xicai]

Hi @Anonymous ,

For all the relationships among the three tables, try to change the Cross filter direction from Single to Both, which will treat the three tables as a single table.

Or could you please share your sample data or 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]

Yes, i have Changed to Both option. Opened Date and Planned Date this all are from same table. 

[v-xicai]

 Hi @Anonymous ,

Based on my test, when you change the Opened Date , the Planned Date changes accordingly. And the Planned Date can also filter the other visual like the Opened Date done .  So I think both Opened Date and Planned Date can filter the other visuals now.

Best Regards,

Amy