Forum Discussion
Sorting in order day month in chart
Hi
I have calendar table with integer number as sorting and I used it in my axis, but it still gave me wrong order for day-month
is there anything wrong ?
- Anonymous5 years ago
Hello created calendar table with date and month date (Dateasinteger) and already click 3 points for short on the chart, but the window windowsill gave me the wrong order
5 Replies
- amitchandak
Super User
Anonymous , Have marked it sort column correctly. And have sorted on the date from three dots on the visual
Looking at the visual seem like ascending on value
- AnonymousNot applicable
Hello created calendar table with date and month date (Dateasinteger) and already click 3 points for short on the chart, but the window windowsill gave me the wrong order
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- v-luwang-msft
Community Support
Hi Anonymous ,
About custom sort,you can see the below,Create a special table for sorting,and could pls provide your pbix file ? Remember to remove the confidential information.
How to create a custom sort order for a visualization?: https://community.powerbi.com/t5/Desktop/How-to-create-a-custom-sort-order-for-a-visualization/td-p/527181
Power BI - Custom Sorting in 3 Easy Steps!: https://www.youtube.com/watch?v=4xapOrfLvbg
Wish it is helpful for you!
Best Regard
Lucien Wang
- v-luwang-msft
Community Support
Hi Anonymous ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.Best Regard
Lucien Wang