Forum Discussion
dilledille
2 years agoNew Member
Dynamic Text in Text Box or Card based on slicer selection
I am trying to change the text in a text box or card based on a slicer selection. For example, if i select a country "Afghanistan", I want the text box to read "The War in Afghanistan began in 20...
ExcelMonke
2 years agoImpactful Individual
You could probably do something along the lines of a measure with:
TextBoxText =
Lookupvalue(Table[Origin/Destination]),Table[Country of Origin],SELECTEDVALUE(Table[Country of Origin])
)One important note is that this is assuming that each Country of Origin is unique