Forum Discussion
Happytravel2025
1 year agoRegular Visitor
Dynamic text box and Card?
Hello, I am wondering if there is any way I can change the text box and card as the pic based on the change of the slicer?
- 1 year ago
Hey Happytravel2025 ,
you can create measures that return a value based on the selection inside a slicer, then you can add the measure to the textbox's title.
Inside the measure, use SELECTEDVALUE( ...) to store the slicer selection inside the variable.
Then, if necessary, use SWITCH( ... ) to return the value you want to visualize.
Hopefully, this helps to tackle your challenge.Regards,
Tom
Bibiano_Geraldo
Super User
1 year agoHi Happytravel2025 ,
You have to use SELECTEDVALUE function, something like this:
SelectedCategoryText = SELECTEDVALUE('YourTable'[YourColumn])