Text Slicer SELECTEDVALUE Not Working

[WishAskedSooner]

Hi Experts!

Does anyone know the DAX equivalent of SELECTEDVALUE for the new Text Slicer because SELECTEDVALUE does not seem to work.

TIA!

[WishAskedSooner]

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.

[v-menakakota · Accepted solution]

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 Learn

As 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 

[v-menakakota]

Hi @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

[v-menakakota]

Hi @WishAskedSooner ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you

[v-menakakota]

Hi @WishAskedSooner ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.