Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
Hi
I have a text filter which filters by graphs by store:
And a graph which plots each store against a value:
To stop Power BI from treating the stores as integers and summarizing the values, I've made the 'store' column a text column. Is there a way to sort the values within the filter as if they are numerical? Rather than 10, 102, 105, 106 it would be 10, 11, 102, 105, 106 etc. I can sort the filter by changing the 'store' column from text to whole number but it causes this to happen:
I've tried to change the default summarization but I don't have the option to (greyed out).
Thank you
Solved! Go to Solution.
Hey @carpetwotsit
I would recommend creating a calculated column that converts the store number to text like:
StoreText = FORMAT(Test[Store], "####")
Then you can go to the Data tab and sort the StoreText column by Store. Then by putting StoreText in the axis of your visualization, you will have the proper functionality. Use the Store in any slicers though.
Hope this helps,
Parker
Hey @carpetwotsit
I would recommend creating a calculated column that converts the store number to text like:
StoreText = FORMAT(Test[Store], "####")
Then you can go to the Data tab and sort the StoreText column by Store. Then by putting StoreText in the axis of your visualization, you will have the proper functionality. Use the Store in any slicers though.
Hope this helps,
Parker
Thank you, exactly what I needed!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |