Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
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.
Proud to be a 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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |