Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Point cloud and sorting

I created a Point Cloud based on a table where each line as a unique identifier.

The X Values of the Point Cloud is a car registration date.

The Y Values is a selling price.

The Legend is the unique identifier.

 

I would like to sort the graph by ascending car registration date, but it is always sorted by ascending Legend (unique identifier).

How can I correct it ?

Thank you for your support

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Can you provide a screenshot of your visual? We can better understand the problem and help you. Please remove any sensitive data in advance.

     

    Best Regards,
    Community Support Team _Yuliax

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you  - Here I provide the screenshot:

    As you can see, instead of sorting by the X Axis (month) he starts to sort by Legend (vehicule reference). How can I avoid it?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 

       

      From the screenshot it looks like your date column data type is text, so it can't be sorted by month, you can try to change the date column to the Date Data type.

       

       

      If you are still having problems, you can provide sample data so that we can help you better: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or excel. Please remove any sensitive data in advance.

       

      Best Regards,
      Community Support Team _Yuliax