Forum Discussion

sainig546's avatar
sainig546
Frequent Visitor
4 years ago
Solved

Drillthrough filter

Hi all, i have a requirement where i need to show count of ids on the main page and than using  drill through its detailed data , the measure i am using to count ids shows current+last month data w...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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.

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Can you share a demo pbix file with same structure and I'll give it a go.

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    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.

    • sainig546's avatar
      sainig546
      Frequent Visitor
      4 years ago

      on the card it should show the count of id in last month + current month since there is only one value for december its showing one, in the drillthrough it should show all the detail for that id like created date ,updated date ,id