Forum Discussion
Input Slicer Case Sensitivity
We use input slicers in PowerBI with a Direct Lake connection. The slicers didn't use to be case sensitive but with the latest release it now appears that they are which, unfortunately, significantly reduces the slicer's utility. Does anyone else notice this issue? Are there any plans to either add a case sensitivity setting or remove the case sensitivity?
Hi nyradmin ,
i think there are ways to change collation in the fabric.please go through below links to understand it further.
- https://blog.fabric.microsoft.com/en-us/blog/whats-new-and-coming-soon-in-sql-analytics-endpoint-in-fabric/
- https://learn.microsoft.com/en-us/fabric/data-warehouse/collation
- https://powerbi.microsoft.com/en-us/blog/announcing-semantic-model-apis-to-update-culture-and-collation/
Let me know if these links were of any help
we might get more updates after the SQLCon too.
Please give kudos or mark it as solution once confirmed.Thanks and Regards,
Praful
LinkedInHi nyradmin ,
Thank you for reaching out to the Microsoft Community Forum.
There is no visual‑level setting. Slicer visuals in Power BI do not have a built‑in option to ignore case sensitivity.
please try below alternative workarounds.
1. Normalize text in the model, In Direct Lake create below DAX measure.
SearchName =LOWER ( 'Table'[Name] )
Then use SearchName in the Input Slicer. Display the original-cased column in visuals.
2. Create a SQL view or notebook transform using LOWER() or UPPER(). Point the slicer at that standardized column.
Please refer below link.
Solved: Case sensitive slicer when using direct query - Microsoft Fabric Community
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
4 Replies
Hi nyradmin ,
i think there are ways to change collation in the fabric.please go through below links to understand it further.
- https://blog.fabric.microsoft.com/en-us/blog/whats-new-and-coming-soon-in-sql-analytics-endpoint-in-fabric/
- https://learn.microsoft.com/en-us/fabric/data-warehouse/collation
- https://powerbi.microsoft.com/en-us/blog/announcing-semantic-model-apis-to-update-culture-and-collation/
Let me know if these links were of any help
we might get more updates after the SQLCon too.
Please give kudos or mark it as solution once confirmed.Thanks and Regards,
Praful
LinkedInHi nyradmin ,
Thank you for reaching out to the Microsoft Community Forum.
There is no visual‑level setting. Slicer visuals in Power BI do not have a built‑in option to ignore case sensitivity.
please try below alternative workarounds.
1. Normalize text in the model, In Direct Lake create below DAX measure.
SearchName =LOWER ( 'Table'[Name] )
Then use SearchName in the Input Slicer. Display the original-cased column in visuals.
2. Create a SQL view or notebook transform using LOWER() or UPPER(). Point the slicer at that standardized column.
Please refer below link.
Solved: Case sensitive slicer when using direct query - Microsoft Fabric Community
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi nyradmin ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi @nyradmin ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh