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!
Hello!
I had this problem for a while to. You need to make sure you have the date(or day) tab in your excel sheet to match up with the months. Then if you go into power bi and highlight the months catgetory for the data you are plugging in and look under the modeling tab at the top you will see " Sort ", if you click that you cant sort by date making the months in order! hope this helps
Kindest Regards,
Clay
Thanks Clay for the fast response.
My fault here but can you explain what you mean by "You need to make sure you have the date(or day) tab in your excel sheet to match up with the months."
Thanks again.
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!
Thankyou, that is perfect, all working now.