Forum Discussion

DLB13's avatar
DLB13
Icon for Helper I rankHelper I
5 years ago
Solved

Dynamic text?

Hi all -    I have a bit of an atypical use for Power BI I'm trying to find a workaround for, even though I know it's not an ideal use. Basically, I need to display several sentences of text depend...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    The basic approach would be to write a measure like

    TextToDisplay = SELECTEDVALUE ( Sheet1[Text], "Placeholder Text" )

     

    This will return the text value if there is only one in the current filter context and the placeholder text otherwise. For your dataset, you'd need filters or slicers set on both Project Number and Card Location, or else the text won't be unique and the measure would return the placeholder text.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

The basic approach would be to write a measure like

TextToDisplay = SELECTEDVALUE ( Sheet1[Text], "Placeholder Text" )

 

This will return the text value if there is only one in the current filter context and the placeholder text otherwise. For your dataset, you'd need filters or slicers set on both Project Number and Card Location, or else the text won't be unique and the measure would return the placeholder text.

  • DLB13's avatar
    DLB13
    Icon for Helper I rankHelper I
    5 years ago

    Thank you, this is exactly what I needed!