Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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?
Solved! 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!
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!
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...
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |