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.

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
2 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
    2 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).

    • SusanRay's avatar
      SusanRay
      Icon for Helper I rankHelper I
      2 years ago

      Hello gmsamborn ,

       

      I apologize if I wasn't clear. I am still very new to Power BI and Dax. 

      Color Parameter is just that, a parameter. ( a 'fields' parameter if that helps)

       

      My use case: 

      I have one page with a stacked bar graph that changes the legend colors based on the Color Parameter selection (Gender, Race/Ethnicity or Residency, etc.).   

       

      A user can select a portion of a bar and drill through to another page. That page, of course, only shows data relevant to the particular bar and color selected.  

       

      I need a way to title the drill-through page that clearly indicates what was selected on the previous page (for example "Male" or "Asian" or "In-State").  The exact verbiage will vary depending on which parameter was chosen.

       

      I am struggling to find the correct DAX syntax for that purpose.  

       

      Does any of that make sense?