Forum Discussion
Sort month date table
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!
Hi Anonymous
see a docs here
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
5 Replies
- az38Community Champion
Hi Anonymous
see a docs here
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
- AnonymousNot applicable
Hey thanks!
Another question - now at the total number there is no comma, how can I add a comma seperator?
- az38Community Champion
Anonymous
pick your formatted column at the right pane, then set decimal numbers in Column/Measure tools ribbon