Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
Hi @Anonymous
see a docs here
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
Hi @Anonymous
see a docs here
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
Hey thanks!
Another question - now at the total number there is no comma, how can I add a comma seperator?
@Anonymous
pick your formatted column at the right pane, then set decimal numbers in Column/Measure tools ribbon
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!
@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
User | Count |
---|---|
85 | |
76 | |
73 | |
70 | |
56 |
User | Count |
---|---|
104 | |
99 | |
93 | |
78 | |
69 |