Input Slicer 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
LinkedIn 

Hi 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