Forum Discussion

JoeyLenz's avatar
JoeyLenz
New Member
1 year ago
Solved

PowerBI Drill-through help

Hi!

 

Newbie to PowerBI and trying to configure a drill through. I have a matrix which has the following fields:

Rows: Month End: Shows the last day of each month.

Columns: Region: APAC, EMEA, GLOBAL and TOTAL

Values: Open OD (the sum of a column that is either 1 or 0), Open ND (sum of a different column that is either 1 or 0) and Open issues (same as before but different column).

 

I have a drill-through target that is a table. When I set up my filters on the drill-through, it successfully filters for the region and month end. But I want it to filter for row items where the values have a '1'. I.e. if I click on Open OD for October 23 for the Americas region, it shows all row items with October 23 in the month end field, Americas in the region field and 1 in the Open OD field. And similarly if I click on Open ND for americas in October 23 it does the same but filters for 1 on the Open ND column. 

When I drill through it doesn't automatically select the '1' values when 'used as category;, it has a selection box of either 1 or 0. 

 

What can I do to get the filters working for Open OD, Open ND and Open Issues?

 

Thanks in advance!

 

SSs of the matrix: 

SS of the config of the matrix and filters:

Config of the drill through filters (it doesn't auto select Open OD when I click of April 24 Americas):

 

  • Thanks for your reply! 

     

    If it is not possible, I am thinking of just having a seperate page with the report and slicers the end-user will have to configure themselves. Not as swanky but at least you will get the same result.

3 Replies

  • As far as I am aware you can't do it. I've tried a few times to be able to use the value of the measure as a drill through parameter, but never managed to get it working.

    • JoeyLenz's avatar
      JoeyLenz
      New Member

      Thanks for your reply! 

       

      If it is not possible, I am thinking of just having a seperate page with the report and slicers the end-user will have to configure themselves. Not as swanky but at least you will get the same result.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi, JoeyLenz 

        It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

        This will help others in the community to easily find a solution if they are experiencing the same problem as you.

        Thank you for your cooperation!

         

         

        I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
        Best Regards,
        Fen Ling,
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.