Using Drill down with parameters

Hi,

Is it possible to use drill-down with parameters? I have a clustered bar chart visual that uses a parameter but I need the drill-down to show the different sub-catergory for each of the fields in the parameter. The parameter is this:

SupportParameter = {

("Primary Support", NAMEOF('Referral'[primarysupportrequired_display]), 0),

("Additional Support", NAMEOF('Referral'[additionalsupportrequired_display]), 1)

}

I would like the drill down to show the Other option for the Primary and Additional categories, depending on which the visual is displaying. At the moment I can only get it to move down the hierarchy so it isn't showing accurate information.

Any help would be much appreciated!

Need Help

Anonymous
1 year ago
Hi Naomig2088 ,

Turn on the drill down option by selecting a single down arrow. Drill down one field at a time, a gray background indicates that the drill down option is turned on. The double-arrow drill-down icon drills down to all fields on the canvas at the same time. Your understanding is correct, drill down one layer at a time.

More detailed information can be found in the documentation:

Drill mode in the Power BI service - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.

7 Replies

Anonymous
Not applicable
1 year ago
Hi Naomig2088 ,

You can try to use drillthrough. With drillthrough in Power BI reports, you can create a destination target page in your report that focuses on a specific entity such as a supplier, customer, or manufacturer. When your report readers right-click a data point in other source report pages, they drill through to the target page to get details that are filtered to that context. You can set up drillthrough in your reports in Power BI Desktop or the Power BI service.

You can refer to this example below.
In Page 1:

In Page 2:

Eventually you can drill through in page 1.

Then it will jump to page 2 and display the following.

More detailed information can be found in the documentation:
Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Using Drill down with parameters.pbix96 KB
- Naomig2088
  Helper II
  1 year ago
  Hi Clara,
  
  Thank you for your response. I understand what you're saying but it's not working for me, unfortuately. The drillthrough doesn't show any more detail than I already have in the original visual.
  
  To clarify, what I would like to achieve is when I select 'Other' I can see a breakdown of what subcategories this is comprised of:
  The breakdown exists as a separate field, so I'm not sure how to achieve this. Similarly, my Additional Support also has an 'Other' option with subcategories, which I would also need to see a breakdown of. Is there any way to achieve this? Any suggestions are very welcome! Thank you.
  - Anonymous
    Not applicable
    1 year ago
    Hi Naomig2088 ,
    
    Based on your description, I created this data.
    
    Put these fields in the bar chart and turn on drill down.
    
    Subsequently click on OTHER or other fields to see the subcategories.
    
    If your Current Period does not refer to this, please clarify in a follow-up reply.
    
    Best Regards,
    
    Clara Gong
    
    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Using Drill down with parameters1.pbix32 KB