Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi. I dont understand why cant I sort by month.
Im using scatter chart. and I have already created new column to be sorted by x-axis. Is scatter chart cant be sort?
Solved! Go to Solution.
Hi @Anonymous ,
Have you tried this?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @Anonymous ,
Please let me know if the method I provided in my last reply is helpful.😉
Best Regards,
Icey
@Anonymous , Make sure the sort column is defined. and you have sorted on month using three dots.
@Anonymous , you can create month column and sort that on month no
Month = FORMAT([Date],"mmmm")
Month Year sort = month([Date])
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
@amitchandak can you please have a look at this? https://1drv.ms/u/s!AoKh3nlpMpSOgmSAg1TMiavknFhn?e=NDMg6m
@Anonymous , I create a date table with month name and month in that table, joined it with your table and done changes in viusal. but it has not changed the sort order. still checking.
@amitchandak really appreciate if you could help me with this. thank you in advance! 🤗
User | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |