ofir_n1's avatar
ofir_n1
Frequent Visitor
5 years ago
Status:
New

bug - x axis line scatter chart cand handle dates

hi

i am trying  to put on the x axis , there is no way to sort the date on the Axis 

 

3 Comments

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support

    Hi, ofir_n1 

    According to my test, I can correctly sort the X-axis using the Sort by->Date column in the scatter chart like this:

     

    If you can’t sort by the data column, I think you should first go to check if your date column is the “Date” type rather than the “Text” type, because the “Text” type of date can’t be sorted correctly.

     

    More info about the scatter chart

     

    Best Regards,

    Community Support Team _Robert Qin

  • ofir_n1's avatar
    ofir_n1
    Frequent Visitor

    Hi,  v-robertq-msft 

    i tried it and also sort by other coumn( like dateint) but nothing  is working there is a seriuos bug with that.

    thanks

     

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support

    Hi, ofir_n1 

    Have you clicked on the “Sort by column” option for your date column to sort the date column by the value of other columns?

     

    Because it will also lead to the incorrect order of the date column.

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column#sort-using-the-sort-by-column-button

     

    If not, I suggest you to share the pbix file with the problem with us so that we can help you to determine if it’s a real bug in Power BI.

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin