Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to get bar/box plot showing single data points?

Hi people, I have a set of data, which can be divided to two groups A and B. I wanted to build a graph, where A and B would be on X-axis, and all the single corresponding data points would then be sh...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    Try one of the dot plot options in the Get More Visuals AppSource. Or you could build it easily with the Charticulator or Deneb visuals.

    Pat

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi， Anonymous ;

If I understand you correctly, you can use a bar chart, if you want to show the average, you can create a measure and then put in the value. like below:

averg = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Cate]))

The final output is shown below:

If not, please share more details?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your answer, but I rather meant something like this. I finally managed to do it with an additional dot plot option, as suggested another commentator. This graph is not ideal but is the closest to what i wanted (among what i have found for PowerBI).