Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
adam_wyrwol
New Member

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

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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors