Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have several tables in my report. To link all of the tables together and have single filter to search by "Client Name & ID" I created a Client ID & Name table with a relationship ID column. I created a relationship ID column in all other tables to manage the relationships and link tables. I can now have all tables on one sheet and the single filter (i.e. Relationship ID) filters all the tables.
My issue is, I have date columns in each of the tables as well. I have a master date table with only dates (DateKey_2). I tried linking all the other tables to the DateKey table to have another single filter for dates, but this did not work - not sure why.
Can someone help me with creating relationships amongst all tables based on dates? My ideal outcome would be that I have only two slicers: (1) Client Name & ID and (2) Date.
Thank you!
Solved! Go to Solution.
Hi @kpangelinan,
Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.
Best Regards!
Dale
Hi @kpangelinan,
It's clear as you posted that the column to create a relationship is the column of dates. What is the outcome when you established the relationships? Could you please check these items below:
1. If the column in one side of the relationship is a datekey, so the column in the other table should also be a datekey. It's the same if the column is a date.
2. The date table, DateKey_2, should have at least one date column.
Best Regards!
Dale
Hi @kpangelinan,
Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.
Best Regards!
Dale
I had an issue when trying to create multiple relationships, so just settled with the dates. Creating the relationship between the dates was easy enough and worked. Thanks for your time and help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |