Forum Discussion
Drillthrough filter
See what you make of this:
Drill Through Example
You were making life hard for yourself and slowing power bi down by converting your dates to text strings to join on. I think you may have something odd coming in from power query so go into it and make sure column types are set as Date not datetime.I then improved your date table and was able to tidy your filter logic.
Finally there is then a visual filter set on the drill through table equal to 1
If you're unsure of anything I've done please reply and can help.
I'd be really interested if anyone has a better solution because I've hit this in the past.
I got round it by building a measure with the same logic baked in that returned either 1 or 0 depending on whether a row should be shown or not. Then used that measure as a visual level filter on the visual table on the drill through page. Think you could do something similar here.
Hi bcdobbs,
i think it can work but how do we implement that here using calculatetable?
sorry i am still rather new to this so if you can with an example query that would be great
Can you share a demo pbix file with same structure and I'll give it a go.
https://drive.google.com/file/d/1BlcC10zXivrHOug7OrNCN7k6GSk5manC/view?usp=sharing
here is the pbix link ,dont see an option to share file here
Hi, just looking and trying to understand the original measure.
What should be being displayed when no month is selected? It just shows 1 when I do it on the demo file you sent.
Can you share a demo pbix file with same structure and I'll give it a go.