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
2 years ago

Hi gmsamborn ,

If you look at the Enrollment Count Detail Page,  you will see a text box that includes the phrase (Color Parameter Selection). That is where I hoped to put the "Drillthrough Title Piece."   (My bad. I wasn't consistent in my naming.)

 

Power BI did not throw an error when I created a measure using your proposed code. ğŸ™‚

But when I tried to 'add dynamic value' to the text box I am using for the title on the 'detail' page it wouldn't accept it. ğŸ˜•

 

 

I then tried to add it as a table or a card, but it gave me a "Couldn't load the data for this visual" error. ğŸ˜•

 

Specifically, it says, 

 

 

As I said, I am very new to Power BI. This is supposed to be a Measure, right?  Does it matter where that measure sits in my data?

 

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi SusanRay 

I for got to mention that when you are setting up your dynamic value, don't forget to use [ and ] (ie. [Drillthrough Title Piece] )

 

Also, the location of a measure doesn't matter.  (I usually set up an empty table to put them in.)