Forum Discussion
line chart
- 9 years ago
Anonymous
Hi, you don't need a line chart to sort the months
Check this link :
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/
or you can watch this video
https://www.youtube.com/watch?v=swJwaWIvVGg
Regards
Victor
Lima - Peru
Anonymous
Hi, you don't need a line chart to sort the months
Check this link :
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/
or you can watch this video
https://www.youtube.com/watch?v=swJwaWIvVGg
Regards
Victor
Lima - Peru
Hi Victor,
Thanks for the link and the video.
The date range of my data is acually controlled by the date slicer that I created. I've tried to follow the description from the link; however, the "Sort by Column" is always inactive.
If I do sort by month, then the month name is sorted in alphabetic order but not in chronological order.
Thanks again for the support.
- Anonymous9 years agoNot applicable
You have to select your month column to make that button active. Click on Month in that table.
- Anonymous9 years agoNot applicable
Hi Anonymous,
A KHorseman said, if you choose a column, the button will activate. But I think it not works on your side, because sort by column feature only available on unique value, if you try to apply it at columns who has duplicate values, then you will get below error message.
For you scenario, I think you can drag a date column in axis , switch to hierarchy mode and keep month only.
Regards,
Xiaoxin Sheng