Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi have 2 tables:
1. Calendar: has daily dates for 4 years
2. Fact table: Sales of weekly data
Relationship is on to many.
When I add Date from the calendar table in to a slicer to filter for specific dates, the dropdown shows all dates from the calendar date rathern than only dates where they both have data in common.
Is there any way to get around this other than using the Date column from the Fact table (sales table)?
Solved! Go to Solution.
IMO, the best solution for this is set the direction filter for both:
There are other solutions, like lateral filters, where "Units" > 0.
Hi @LuizKoller Thank you for your response. I like your suggestion of changing the directional filter, but it does not appear to work on my side. Would there be any other changes I can make?
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |