Text value treat as a decimal number if it is used in the filter

[adam_wyrwol]

Hi,

In my dataset I have the record ID column.

This column cointans number of chapter and the next numer of line in the chapter as below:

1.1, 1.2, .... 1.11, .... 1.xxx, 2.1, 2.2, .... 2,122, .... , 2.xxx

In the power query the data type is set up as text value, but when I put it to the filter Power BI treat it as the decimal number.

In the single choice fillter I selected value is equal 1.1 and on the report it is count/sum all 1.1, 1.10 and 1.100 etc.

The effect is that for my question how many times the 1.1 exist in the table I've got answer how many times 1.1, 1.10 and 1.100 exists. Can someone help me what I am doing wrong or how I can change the filter properties? to get proper answer for my question.

[amitchandak · Accepted solution]

@adam_wyrwol , Check the Data type in the Column tools. Click on the column in report/data view, There will be a tab for column tools. Make sure data type is text there

You can use search or containsstring for that

SEARCH and FIND: https://www.youtube.com/watch?v=mZt0HJw4gjQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=45

CONTAINSSTRING and CONTAINSSTRINGEXACT: https://www.youtube.com/watch?v=XbgLGDvWdWQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=44