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.