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.
Hello guys,
I have two tables, the main table is called "Ano 2019" and the other table was acheived by duplicating the main table and is called "Ano 2019 (2)". In both tables I have date columns. I have created table visualizations and a date slicer to choose the months I want to observe, but only one of the tables is filtered by the chosen month because there is no relationship between the date columns from the two tables.
I already tried to stablish relationship between the date columns in the relationship manager, but instead of the expected result, one of the date columns loses the date hierarchy and only the data from one table is filtered. But what I wanted was a slicer to chose a month and all the data in the tables are filtered
Follows a example of what happens with my report:
Solved! Go to Solution.
Hi @Anonymous
I can reproduce your problem.
To solve this, i ceate another date table, create relationships as below and add columns from this date table as slicers.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
I can reproduce your problem.
To solve this, i ceate another date table, create relationships as below and add columns from this date table as slicers.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Create a date dimension as below and define relationship from date to other two tables. Use the month from Date dimension in slicer.
Calendar = CALENDAR(MIN(Ano 2019[DATE COLUMN]),MAX(Ano 2019[DATE COLUMN]))
If it helps,mark it as a solution
Kudos are nice too..