Forum Discussion
Filtering by connecting tables
Can you post the pbix? or at least some sample data?
Generally, it's usually best to not set up bidirectional filters in the model unless you really have to. Usually better to CROSSFILTER and only "turn on" for that process.
Hi there Anonymous and thank you for taking the time to reply to this.
Please find in the links below sample of my 2 excel files:
https://www.dropbox.com/s/k3xbs705s5q2nld/sheet1.xlsx?dl=0
https://www.dropbox.com/s/44hjbbzn88c1xam/intimp.xlsx?dl=0
and here is how my report looks like and the relationships I have made up to now,
The slicers are made with data from the Intimp but the doughnut is made from the sheet1, right now with the relationships I have made I can choose a retailer and the doughnut changes but I cant do the same with date.
I need to have both at the same time, so whenever I change date or retailer I need the Doughut to be responsive.
Thank you again,
Kind Regards.