I want to remove users which start with "d" and not "D" in power bi desktop

[NISH72]

The report level filter is not case sensitive and i want to create a report level filter which removes users starting with "d" and not "D". How to do it Please reply ASAP. Thanks

[Anonymous · Accepted solution]

Hi @NISH72 

You can use unicode and IF.

Then filter according to the new column values.

For example:

Column = If(UNICODE(LEFT(Table[Column],1))=100,1,0)

If the first letter equals to 100 which is 'd' then value is 1.

Then filter all 1.

Cheers!
A

[NISH72]

And I want to add it as a report level filter

[Anonymous]

Hey @NISH72 

Each character in the world has a unique code. So 'D' is different than 'd'.

You may use the filter wherever you want. Visual, Report, Page.

Thanks

A

[NISH72]

Is it case sensitive