Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Drill through button

Hi, 

I have an overview page with multiple graphs. For example, I have a barchart with Sales data, a Categories graph and a Spend graph. They all have their own Page with details.  Now I want to create a drill through button,that only is clickable/works when a graph is selected and will navigate to the the detail page of the selected graph. 

 

For example if I select something in the graph Spend I want to go to the Spend page in my report. 

Bellow a quick image to visualize. (So if I select a bar in spend view, I want to be able to navigate to the spend page with the filter, the same for the other graphs preferably with the same button).

 

Thanks a lot! 

 

EDIT: Maybe a small clarification. Every graph shown has its own detail page, I want one button to drillthrough/go to the detail page of the selected graph. For example when I click on sales the button will be active and navigate me to the sales detail page. 

 

 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you Anonymous,

      That was indeed helpful. 

      I'm new to DAX and love to learn it, by looking it up but I couldn't figure this out.   

      Using the example from the video I figured I could change AND to OR which works pretty wel. 

      But I run ito two issues with changing the script from the video: 

       

      1. How do I remove the slicers used in the video from the script? 

      2. Is there a way to use the OR function with more than two options? 

       

      I hope you can help me out, 

       

      Thanks again! 

       

       

      Drill Navigation with Page = 
VAR _spage =
    SELECTEDVALUE ( Navigation[Page name], "" )
RETURN
    IF (
        OR(
            HASONEFILTER ( 'Sales Territory'[SalesTerritoryCountry] ),
            HASONEFILTER ( Customer[Customer Name] )
        ),
        _spage
    )