Forum Discussion

Jan_Trummel's avatar
Jan_Trummel
Helper IV
4 years ago
Solved

Dynamic drillthrough button doesn't work

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

 

 

5 Replies

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

     

     

  • 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!