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"
Hi Rahulmg2002
Even then, one item IDs incorrect count being lower than correct is plotted lower and then another IDs incorrect being higher count than correct is plotted higher on the same y scale, how that should be done?
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"