Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
refer : https://www.youtube.com/watch?v=KK1zu4MBb-c
@Anonymous , check the selected column, it should be the month name. I see some different column name on column tool
@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! 🤗
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |