Forum Discussion
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...
I wouldn't bother nesting sentences in IFs, Switches or variables. If it's text you want to maintain / control, you could either use 'Enter data' and have a Country and Description column, or the same in an Excel file. Then on your slicer you'd have the column Country and on the card visual you'd have the description column.
If you already have the descriptions in another table, then assuming that table has a 'country' column (or any key unique key column) you could create a relationship between your country lookup table that you're using for the slicer and the key in the description table.