Using Drill down with parameters

[Naomig2088]

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!

[Anonymous]

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.

[Naomig2088]

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]

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.

[Naomig2088]

[Anonymous · Accepted solution]

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.

[Naomig2088]

Thank you so much for your help with this.

[Naomig2088]

Hi Clara,

Thank you so much for this. However, my report is producing incorrect results as there are 2 sub fields for Other- one for Primary and one for Additional. So when I click on the Other in Additional, it's drilling down to the Other sub category for Primary. I'm thinking it's because it's higher in the hierarchy? Thank you for your ongoing help.