Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm connection Live to Power BI with Tabular model.
I want to use a filter on a string field using advanced option of "contains". I've noticed it is not case sensitive, so if the condition is field contains "OF" I get results also for field contains "of".
Is there a way to apply case sensitive filters somehow?
Thanks!
Hi @Yael,
Based on my test, it is by design that Visual level filters/Report level filters/Page level filters are not case sensitive. The only workaround is to apply filter via DAX.
Regards,
Yuliana Gu
Hmm, I know that FIND is case sensitive.
https://msdn.microsoft.com/en-us/query-bi/dax/find-function-dax
thanks @Greg_Deckler, but I was hoping to use the out of the box filtering capabilities Power BI has instead of using DAX.
It seems that the out of the box advanced filtering of "contains" is not case sensitive.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |