Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gjakova
Post Patron
Post Patron

Scatterplot won't sort chronologically

Hi there,

I'm developing a dashboard where the scatterplot is the most important function of the dashboard. I have multiple tables and for the scatterplot I am using measures from three different tables:

  1. Scores of Employees --> 1 till 10
  2. Period --> P1F1, P1F2, P1F3, P1F4, P2F1, P2F2, P2F3, P2F4, P3F1, P3F2, P3F3, P3F4, P4F1, P4F2, P4F3, P4F4
    1. P = Period (1 - 4) and F = Fase (1 - 4)
  3. Year = 1 till 4

Gjakova_0-1595170166137.png

Above you can see the X-axis (I removed the P and F, so 1-1 = P1F2

The third number is the Year

As you can see now, everything is sorted perfectly, but once I add the names of the employees in the Legend it looks as follows:

Gjakova_1-1595170528718.png

It start with 1-1 3 instead of 1-1 1

Due to this the whole function of the scatterplot fails and thus the whole dashboard... I tried everything to sort it out correctly, but I keep failing. Does someone have some suggestions?

1 ACCEPTED SOLUTION
Gjakova
Post Patron
Post Patron

I found the solution, or at least a solution that worked for me:

When you format the scatterplot, go to Y-Axis and let it start at 0.1 or 1.

Go to show blank values and select: ON.

Thanks to this trick it sorted everything fine. This might also help someone out which the same problem. Hope it works for you too!

View solution in original post

3 REPLIES 3
Gjakova
Post Patron
Post Patron

I found the solution, or at least a solution that worked for me:

When you format the scatterplot, go to Y-Axis and let it start at 0.1 or 1.

Go to show blank values and select: ON.

Thanks to this trick it sorted everything fine. This might also help someone out which the same problem. Hope it works for you too!

Gjakova
Post Patron
Post Patron

I did some tests and it seems that the order is influenced by the names in the legend. Since the first person from my list was only active in year 3, problem is that I need to see all the dots, thus need to divide the data into the employees...

According to this article, scatter plots cannot be sorted manually:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort

Not all visuals can be sorted. For example, the following visuals cannot be sorted: treemap, map, filled map, scatter, gauge, card, waterfall.

Check that everything is set to 'don't summarize' and perhaps may have to create a numerical value for the period rather than one with the - in it.

This video around 5:10 shows scatter plot with legend behaving as expected:
https://docs.microsoft.com/en-us/power-bi/guidance/report-tips-sort-distribute-data-plots

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.