Forum Discussion
Solved
PowerBI Scattered chart sorting
Hello All, i have scattered chart Visual in powerBI, on x axis i have item ID field , and on Y-axis Mean scale score field, legend is " Response" field ( correct/ incorrect). when i plot the chart, o...
hello mahenkj2 , thank you suggestion to use line chart. i manage to produce the result. couple of twicks i have done.
- line chart and only showing markers.
- create 3 measures, for avg. correct, avr incorrect and sort order mearsure where avg. of incorrect is great than avg. of correct.
- put that measure in 'tooltips' and sort the visual by "sort order"
Rahulmg2002 , Scatter on only sort on X-axis and y-axis and legend, Legend sort will force the axis to sort ascending on axis column