Sort month date table

[Anonymous]

Hey, 

I Created a date table and related the table to my Sales table, which contains a sales per day (date).

Now i Created a "Line and clustered column chart", at the shared axis i put the month from the date table, and at the values i put the sales from my sales table. the visualization shows me the sales sorted from the biggest to the smallest, instead a chronological order (January - June). How i sort the axis chronological?

Thanks!

[az38 · Accepted solution]

Hi @Anonymous 

see a docs here

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort

[Anonymous]

Hey thanks!

Another question - now at the total number there is no comma, how can I add a comma seperator?

[az38]

@Anonymous 

pick your formatted column at the right pane, then set decimal numbers in Column/Measure tools ribbon

[Anonymous]

Thanks! Other issue (instead opening new discussion..):

I Have a graph that orderd in alphabetical order:

In my Date table i created a new column with the number of the day at the week (The full date is in hebrew language):

Now I'm trying the solution you gave me before (Sort the X axis by DayOrder at the "Sort By Column" button), and i get this error message:

What can be wrong? Thanks!

[az38]

@Anonymous 

try to remove new column from bar chart and use this technique https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column instead