Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
JoeyLenz
New Member

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: 

JoeyLenz_0-1730977505195.png

SS of the config of the matrix and filters:

JoeyLenz_1-1730977998063.png

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

JoeyLenz_2-1730978067355.png

 

1 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.

View solution in original post

3 REPLIES 3
johnt75
Super User
Super User

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.

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.

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.