cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fanhui3
Helper I
Helper I

Sort by column not working

Hi, 

I created a sort column for my dataset and sort the data with that column. However, my date axis in my visual is still not sorted. Some help please? Thank you. 

 

I will also enclose my PBIX file here:  https://www.dropbox.com/s/mcvemjaq1166wsc/Price%20Analyser%20Date%20request%20help%20%28sort%20Colum...

 

Sort Column.png

erroreous x axis.png

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

Good

exactly the same thing happens to me, I have tried everything they indicate but it still does not change the order in the graph.

In 'data' it is sorted by the column idmes:

VictoriaMar_0-1634745320537.png

But then the graph is sorted from lowest to highest (and the most recent is left at the end:

VictoriaMar_1-1634745548729.pngVictoriaMar_2-1634745661507.png

Also when I hit the 3 points of the visual object, sorting does not allow me to select the idmes (I have it in columns).

VictoriaMar_3-1634745852277.png

It just lets me sort by the fields that are in rows and Values (which start with p and C):

VictoriaMar_4-1634745924703.png

Would anyone know how to help me? why doesn't you allow me to order by month?

Thank you very much!

mahoneypat
Microsoft
Microsoft

I downloaded your file and got it working from your existing Sort column.  In Data View, highlight/select the Month & Year column, then on the ribbon choose Sort By Column and choose the Sort column.  Then, if needed, hit the ellipsis on the visual and choose to sort it by Month & Year and Ascending.

 

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi Pat! 

 

I did what you instructed and I still see the following. Any idea where else went wrong? 

 

Sort Attempt.png

Still cannot .png

FrankAT
Community Champion
Community Champion

Hi @fanhui3 

I downloaded your sample pbix file and got the following solution:

 

  1.  Select your column Sort and change the data type to whole number.
  2. In data view select your column Month & Year > tab Column tools > Sort by column > choose Sort.

The sort order of the chart axis changes immediatly.

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

HI @FrankAT 

 

 

At this point, I am starting to think there are problem with my software instead of the solutions. 

Sorted by sort.png

Sort Attempt.png

Still cannot .png

Oh yea, I would like to add. The problem only persist in scattered graph. Weird. 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors