Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi people,
I have 2 tables that have various data, two of those columns are Retailer and Date and I want to have in the same page graphs that are affected by the slicer and get data from both of those
I have created distinct tables fro those:
Retailtest= distinct(UNION(VALUES('INt Imp data'[Retailer]),VALUES(Sheet1[Retailer])))
Datetest = DISTINCT(union(VALUES('INt Imp data'[Date]),values(Sheet1[Date].[Date])))
I am able to make a connection of the 2 original tables with the retailertest in bothway relationships and I can see the changes when I choose something in my slicer.
But I am not able to make the same with the datetest table, ideally i would like to have two bothway relationships coming from each of my original tables to the new ones so everything would be connected but I think this is not possible, any ideas?
thank you in advance,
Georgios.
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.