Forum Discussion

SusanRay's avatar
SusanRay
Icon for Helper I rankHelper 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.

SusanRay's avatar
SusanRay
Icon for Helper I rankHelper 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
    Icon for Super User rankSuper 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
      Icon for Helper I rankHelper I
      3 years ago

      Thank you for the response, gmsamborn .

       

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

      • gmsamborn's avatar
        gmsamborn
        Icon for Super User rankSuper User
        3 years ago

        Hi SusanRay 

        I was just going by your definition for [Drillthrough Title Piece].  In you definition, you refer to Color Parameter without using quotes (ie. 'table') or square brackets ( ie. [measure] ).  I have no way of knowing if that is a measure or a table (or even a column).