Forum Discussion
Date Slicer affecting 2 different visuals
Not enough data to work with. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi, here is a more fleshed out example. Apologies if you were wanting a pbix file but I'm current not in a position to put it on an external site and share the link.
The result I want on the drillthrough is for the table there to show only the dates in the month that I have selected on the slicer on and only for the ID # that I drillthrough on.
Table 1
ID Month 1 1/1/2025 1 12/1/2024 1 11/1/2024 1 10/1/2024 1 9/1/2024 2 1/1/2025 2 12/1/2024 2 11/1/2024 2 10/1/2024 2 9/1/2024 Table 2
ID Date 1 1/3/2025 1 1/8/2025 1 12/4/2024 1 11/9/2024 1 11/20/2024 1 11/29/2024 1 9/15/2024 2 1/8/2025 2 12/23/2024 2 11/6/2024 2 10/10/2024 2 9/30/2024 Table I want to show initially (say I set slicer on month to Dec 2024)
ID Month 1 12/1/2024 2 12/1/2024 Table I want to see after drillthrough on ID 1
ID Date 1 12/4/2024 The issue I am having is that all the rows with ID appear
ID Date 1 1/3/2025 1 1/8/2025 1 12/4/2024 1 11/9/2024 1 11/20/2024 1 11/29/2024 1 9/15/2024 I do not know how to get the dates to cooperate on the drillthrough.
