Forum Discussion

SusanRay's avatar
SusanRay
Helper I
3 years ago
Solved

Dynamic Text for a Drill Through

I have created a dynamic text box for the top-level page that changes based on slicer values.   I am struggling with creating a similar text box for the drill-through destination page.   For...
Need Help
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    SusanRay 

    My mistake with that last measure.

    The last line should be returning _Logic not _ColorParm.

    Sorry about that.

amitchandak's avatar
amitchandak
Super User
3 years ago

SusanRay , You can create a measure like below and use that in title

 

Meausre = "Student enrollment for" & selectedvalue(Table[semester]) & " for  selectedvalue(Table[Year])  & selectedvalue(Table[Gender]]) 

 

 

  • SusanRay's avatar
    SusanRay
    Helper I
    3 years ago

    I have been able to create the first part with "Semester," "Year," and "Color Options" as dynamic values in my text box. (Thanks)

     

    However, I cannot figure out how to add the values that are used to focus the drill through.  

     

    For example, If I right-click on the dark blue portion of the Engineering bar and drill through, the table only shows data related to male students in the College of Engineering.  I want my text box on the drill-through details page to state that so the user remembers that the data they are looking at is filtered on those values.

     

    I guess a more general question is, what does P BI call the elements used to focus a drill-through?