Forum Discussion
Text Slicer SELECTEDVALUE Not Working
Hi Experts!
Does anyone know the DAX equivalent of SELECTEDVALUE for the new Text Slicer because SELECTEDVALUE does not seem to work.
TIA!
Hi WishAskedSooner ,
Thanks for reaching out to the Microsoft fabric community forum
The new Text Slicer is currently in preview, and some DAX functions like Selectedvalue() may not behave as expected, especially when users type in custom values or when formatting (like currency symbols) is involved.
Please go through the documentation:
Create a text slicer (preview) - Power BI | Microsoft LearnAs a workaround, you can try using the standard slicer visual instead, especially if you need more consistent interaction with Selectedvalue() or want to avoid issues with manual input.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
5 Replies
OK, I am slowly getting closer. I can return a value using SELECTEDVALUE if I type in EXACTLY a string present in the table.
Is there a way to add a prompt to the slicer? For example, my field is a currency and it would be nice if the $ sign was automatically added when the user clicks on the slicer.
Hi WishAskedSooner ,
Thanks for reaching out to the Microsoft fabric community forum
The new Text Slicer is currently in preview, and some DAX functions like Selectedvalue() may not behave as expected, especially when users type in custom values or when formatting (like currency symbols) is involved.
Please go through the documentation:
Create a text slicer (preview) - Power BI | Microsoft LearnAs a workaround, you can try using the standard slicer visual instead, especially if you need more consistent interaction with Selectedvalue() or want to avoid issues with manual input.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support TeamHi WishAskedSooner ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Thank you
