Dynamic drillthrough button doesn't work

[Jan_Trummel]

Hello community,

I have a Power BI report with 3 pages:

• a main page
• a drillthrough page A
• a drillthrough page B

On the main page I have a slicer and a button:

In the slicer I can select one of the values A or B.

If I select A, the button (that has a drillthough action) should lead to the page Drillthrough A, else to Drillthrough B.

For that I wrote this measure:

Drillthrough destination = IF(VALUES('Table'[Selection]) = "A", "Drillthrough A", "Drillthrough B")

In the settings of the button, I put the measure in the destination option:

Unfortunatelly, the button doesn't work.

Can you help me?

Greetings

[Jan_Trummel]

Hello guys and thank you for your quick answers!

I my case, I really need a drillthrough and not a page navigation.

The example above is only to show, what should happen. In my case it is much more difficult. I try to explain:

On the main page the user can select between different measures. Depent on which measure he selects, the drillthrough button has to lead to different drillthrough pages.

So, how can I realize this functionality in one button?

Hope, you can understand what I mean.

Greetings!

[Pragati11 · Accepted solution]

Hi @Jan_Trummel ,

Are you talking about conditional drill-through in Power BI? If yes then check this blog:

https://visualbi.com/blogs/microsoft/powerbi/conditionally-drill-action-power-bi/#:~:text=The%20Powe....

[Jan_Trummel]

Thank you Pragati11,

that was it!

[Pragati11]

Hi @Jan_Trummel ,

Is your Table with SELECTION column a disconnected table?

If yes, then you really don't need a measure there.

You can direction go to your BUtton Action under formatting option and give this SELECTION column as a destination.

Something like below:

I created a disconnected table with column as shown below:

Then I created a report pade as shown below:

Here Click to Navigate is a page navigation button not drillthrough. You don't need a drillthrough to just naviagte to pages as in your case:

Now under destination for this page give your disconnected table column. In my case it is Page Name:

Make sure your slicer is a single selection slicer.

Now start selecting something in the slicer and then the button will start navigating you to the relevant page. Like one navigation is shown below:

Hope this helps.

[amitchandak]

@Jan_Trummel , Use page navigation button option; as drill through button need some selected value

refer if needed

Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4

Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15