Forum Discussion
Helper ICross Report Drill Through
Helper IBoth calendar tables are literally identical. I did a copy and paste from advanced editor from one to the other. same names, same field name. I did add a few columns to the table in the source dashboard, but that shouldn't matter.
Hi mamsteroonie ,
I build a sample to have a test. I add Date and Category column in Drill through field. Please check your Drill through field. My sample works well.
Result:
You can download my sample, then get another copy and publish them to Power BI Service to have a test. Then compare mine with yours and find the difference.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mamsteroonie
I got really excited because no, I didn't put the Year in the drill through well....I only have measures in there....but when I published and tried your solution, it still didn't work. Notice the filter at top is defaulted to 2022 and the drill through is not overriding it.
- mamsteroonie
So I just downloaded your power bi, saved two copies, published....and tried to do the same thing. Made the Year a drop down filter defaulted on 2022 for the target. Then made the year a drop down filter and selected 2021. Then tried to drill through and it did not override the 2022 filter.
This is driving me crazy! I want to fix this so bad. Thanks for trying to help.
- mamsteroonie
Sorry for all of the replies! Just wanted to share one more thing I noticed. When I converted the year back to at able instead of a slicer in the Target report....the drill through worked.
It appears to be an issue with having the year in a slicer. I wonder why???