Forum Discussion

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
5 years ago
Solved

Drillthrough Navigation and SelectedValue

Good Afternoon All, I have a report wherein I am creating Employee Performance Scorecards. My main page has a bar chart with Employees on the Y- Axis.     I am using the Drillthrough feature to ...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi rsbin 

    Instead of using Bookmark to navigate from page 1 to page 2 use another Drill-through to access page 2. By the way there is a new feature where you can use Button for drill through.

     

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi rsbin 

Instead of using Bookmark to navigate from page 1 to page 2 use another Drill-through to access page 2. By the way there is a new feature where you can use Button for drill through.

 

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
5 years ago

Good Morning aj1973 ,

Started playing with the Drillthrough Button concept, but have hit a snag.  I have created the button, selected Drillthrough as the type.   I think I need to use a function or Measure to tell the Button that "John Doe" is the selected Display Name to navigate to my Page 2.   I have created a Measure

Scorecard2Navigation = IF( HASONEFILTER(DIM_WorkSystemOperators_Bridge[DisplayName] ), "Operator Scorecard Pg 2", "" )

But when I try to assign it to the Destination (fx), it is greyed out and won't let me select it.   I am using a Live Connection to Analysis Services.   Wondering if this is impacting this functionality?

When I display this Measure in a simple Card visual, it works fine.

Any further advice or suggestions?

Thanks again!!