Forum Discussion

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How to do number sorting in slicer using power Bi

I am using slicer and loading values in that.

But, number not coming proper order.

How to sort this properly.. 

I want to sort descending order like 10,9,8,7,.........1

 

 

This is urgent. pls. guide ASAP.

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi saivina2920 ,

     

    Convert your column as whole number data type then click on three dots of your slicer and select asc or desc accordingly:-

     

    Thanks,

    Samarth

     

3 Replies

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi saivina2920 ,

     

    Convert your column as whole number data type then click on three dots of your slicer and select asc or desc accordingly:-

     

    Thanks,

    Samarth

     

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    If you click on the column and check items data type on the modelling ribbon I think you'll find it is set as text. If you change it to whole number it should sort ok.