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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
carpetwotsit
Regular Visitor

Number sorting in text filter

Hi

 

I have a text filter which filters by graphs by store:

 

store.png

 

And a graph which plots each store against a value:

 

event_date_text.png

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:

 

event_date_number.png

 

I've tried to change the default summarization but I don't have the option to (greyed out).

 

Thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

TextSorting.PNG

 

Hope this helps,

Parker

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

 

TextSorting.PNG

 

Hope this helps,

Parker

 

Thank you, exactly what I needed!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.