Forum Discussion
Bar chart not displaying correctly
Of course,
You can see in the picture below that I am sorting by months in the chart, so what I did was make a seperate day collum for the days in numeric order. This is a simple and easy fix to get your months to line up ( if you dont care about the day by which you are sorting). If you sort by day from the modeling tab the months will be in order. I hoped this cleared things up!
Hi
I have exported an excel table into power bi however the bar chart of the data is not displaying how i would like it to. It is being sorted on the x axis in descending value rather than from January through to June as per my table.
How can i rectify this?
Thanks.
Check this post - you need custom sorting
https://community.powerbi.com/t5/Desktop/Sorting-by-Month-as-Text-Jan-Feb-Mar-etc/td-p/9237