Forum Discussion
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...
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.
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.
Thank you, this is exactly what I needed!