Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
7 years ago

Sort by column not available

Hi,   I have 2 columns for month, one displays the month name and the other the month number. This is to allow me to sort the month names correctly (e.g. Jan, Feb,.....Dec) by sorting the month nam...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Sounds like you are in the Service and not the Desktop? Perhaps try putting your month number in the visual and selecting the ellipses and sorting by it?

bo_afk's avatar
bo_afk
Post Patron
7 years ago

Hi Greg_Deckler,

 

Thanks for your quick reply.

 

I am actually using the Desktop version. I've tried that method before, but in the sort by option under the elipse, it doesnt seem to show the trading month number column.

 

I retrieve my data from the "Power BI Datasets" option under "Get Data".

 

 

afk

  • bo_afk's avatar
    bo_afk
    Post Patron
    7 years ago

    Hi,

     

    Is anyone able to help with this? The option to sort by column is not available for me and my months are being sorted alphabetically, which is incorrect.

     

    Thank you!

     

     

    afk

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi bo_afk ,

      If you mean live connection to power bi service, current you can't do customize with data model fields on this mode.

      Regards,

      Xiaoxin Sheng