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 example, if I drill through after clicking on the dark blue portion of the Engineering bar,  I would like the text in the sample below to end with "Engineering" and "Male"   

 

 

Thoughts?

 

 

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.

16 Replies

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

  • SusanRay's avatar
    SusanRay
    Helper I
    3 years ago

    amitchandak 

    Here is a little more detail about what I am trying to do:

     

    The last value I need to include in the title changes depending on the Color Parameter. So, I cannot simply use selectedvalue(Table[Gender]) 

     

    Since Color Parameter = 

    {

        ("Overall", NAMEOF('Enrollment'[Overall]), 0),

        ("Gender", NAMEOF('Student Bio Demo'[Gender]), 1),

        ("Race/Ethnicity", NAMEOF('Student Bio Demo'[Ethnicity Race Group]), 2),

        ("Minority", NAMEOF('Student Bio Demo'[Minority]), 3),

        ("Residency", NAMEOF('Student Bio Demo'[Residency level]), 4)

     

    I tried 

    Drillthrough Title Piece = IF(Color Parameter  = "Overall", "Overall", (If(Color Parameter  = "Gender", selectedvalue('Student Bio Demo'[Gender]), (If(Color Parameter = "Race/Ethnicity", selectedvalue('Student Bio Demo'[Ethnicity Race Group]), (If(Color Parameter  = "Minority", selectedvalue('Student Bio Demo'[Minority]), selectedvalue('Student Bio Demo'[Residency level]))))))))
     
    But Power BI doesn't like this.  Any suggestions?
    • gmsamborn's avatar
      gmsamborn
      Super User
      3 years ago

      Does this help?  I think it was just a matter of incorrectly placed parentheses.

       

       

      Drillthrough Title Piece =
IF(
    'Color Parameter'[Value] = "Overall",
    "Overall",
    IF(
        'Color Parameter'[Value] = "Gender",
        SELECTEDVALUE( 'Student Bio Demo'[Gender] ),
        IF(
            'Color Parameter'[Value] = "Race/Ethnicity",
            SELECTEDVALUE( 'Student Bio Demo'[Ethnicity Race Group] ),
            IF(
                'Color Parameter'[Value] = "Minority",
                SELECTEDVALUE( 'Student Bio Demo'[Minority] ),
                SELECTEDVALUE( 'Student Bio Demo'[Residency level] )
            )
        )
    )
)

       

       

       

       

       

      • SusanRay's avatar
        SusanRay
        Helper I
        2 years ago

        Thank you for the response, gmsamborn .

         

        Unfortunately, that did not work.  The error message says "The syntax for 'Value' is incorrect."