PowerBI Drill-through help

[JoeyLenz]

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):

[johnt75]

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 · Accepted solution]

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.

[v-fenling-msft]

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.