Forum Discussion
PowerBI Scattered chart sorting
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
At first, Incase I understood your requirement, you want to see all incorrect dots higher than correct dots, right?
If so, this visual is perhaps not the right choice. Reason is, Y axis is a numeric single scale and when you see a visual, it bascially maps the numbers on that scale. So how can even a smaller number fit on higher side than a lower number, becuase it has to follow the scale.
additionally, scatter chart are good to show relation between two numeric columns.
Since you just want to see Incorrect over the top, so you can use small multiples with line chart:
Hope it helps.
thank you for your response mahenkj2 . just for more clarification i want to sort thedata point where average of incorrect responses higher than average of correct responses. data points on the Y-axis are based on the average of scale score. hope that make sense.
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"