cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
cherrypbi
Advocate I
Advocate I

Same column filter, but showing different values after converting data type to 'text'

Hello,

I wanted to make my ID column (data type: number) a searchable filter so I've duplicated the ID column and made the duplicated field's data type to Text. However, that I've created same filter with duplicated ID filter (text type) and it's now showing different values in the filter.. any idea why this is happening?

I checked the backend table again where the column was duplicated and everythign seems fine...any advice is appreciated. 

 

ex. the ID (TEXT) filter does not have ID 54 or 83 and other values. 

cherrypbi_1-1673568546762.png

 

 

1 ACCEPTED SOLUTION
bolfri
Super User
Super User

Can you provide a Power BI file with those two columns? You can delete anything else. 😉 

 

Numbers are sort from 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and for text it will be 1, 10, 2, 3, 4... etc.

 

You can select ID (TEXT) and order it by column ID (Number) to check all the values.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
bolfri
Super User
Super User

Can you provide a Power BI file with those two columns? You can delete anything else. 😉 

 

Numbers are sort from 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and for text it will be 1, 10, 2, 3, 4... etc.

 

You can select ID (TEXT) and order it by column ID (Number) to check all the values.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




thank you so much that worked!! I clicked on the duplicated Id field (text type) in the Fields panel then chose "sort by column" and chose the ID column (number type) and it worked in Format pane. 

cherrypbi_0-1673569177645.png

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors