Problem using filter

[ryanchng]

I've created a visualisation using a table. This field takes the value of either "Yes" or "No".

However, when I click the dropdown that currently shows "is less than", absolutely nothing happens. How can I change this filter to only show "Yes" values? I am unable to share the source file due to privacy.

[Anonymous]

Hi @ryanchng 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[Anonymous · Accepted solution]

Hi @ryanchng 

As shown in the screenshot , the format for [judgment] is “text”, so you can see “Yes” or ”No” in Filter , the format for [Value] is “Whole number”, then shows “is less than” .

Please check the format for your column .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sevenhills]

You have to go to the data pane, left side of the power bi desktop, you can see like this. Select the data pane to see above

[ryanchng]

Ok got it, the data type is indeed "Text"

[sevenhills]

I tried creating the table as

I tried creating the table visual and see as ... 

the data type is text

Are you able to see the same ? please let me know

[ryanchng]

My ribbon looks different, I do not see Column Tools. From the filter area, how can I see what the data type is?

[sevenhills]

Can you please check the data type of the column, you are trying to filter? Thanks

[ryanchng]

Hi, as I mentioned, it is string data which takes the form of either "Yes" or "No"