Forum Discussion
Case sensitive slicer when using direct query
Create a column in the source that removes can sensitivity - either lower or uppercase the entire text string.
Hello wardy912 ,
No, there is no option in the ‘Slicer’ visual.
I don't know what your Fabric data source is, but you need to consider managing the case sensitivity issue (lower/upper) in the data source.
If you weren't using a direct query, you could have created a calculated column.
Are you sure you're using a direct query and not a direct lake ?
Please feel free to give a kudo and validate the solution if it suits you.
Have a nice day,
Vivien
Thanks Vivien,
It's direct query connecting to a lakehouse (which as I write this, makes me think we should use direct lake).
Would changing to direct lake fix the issue?
I'll look into a fix for the column in the notebooks
