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:
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:
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?
Go to Solution.
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
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...
Has this post solved your problem? Please mark it as a 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.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.