Forum Discussion

carpetwotsit's avatar
carpetwotsit
Regular Visitor
8 years ago
Solved

Number sorting in text filter

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 summ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

 

carpetwotsit's avatar
carpetwotsit
Regular Visitor
8 years ago

Thank you, exactly what I needed!