Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to create this sort of chart in Power BI desktop?
Time along the x-axis, categories on the y-axis and a count of something which would determine the size of the bubbles.
Solved! Go to Solution.
You should be able to do that with one of the Dot Plot options (e.g., the one by MAQ) in the Custom Visuals marketplace (hit the ellipsis in the visuals section and choose Get More Visuals). Since you are using Year, you can plot that as a number on the axis in the Dot Plot and it should work. If you have two category columns to compare, I don't think it would work, and you would need Charticulator or use SVGs in a matrix visual.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You should be able to do that with one of the Dot Plot options (e.g., the one by MAQ) in the Custom Visuals marketplace (hit the ellipsis in the visuals section and choose Get More Visuals). Since you are using Year, you can plot that as a number on the axis in the Dot Plot and it should work. If you have two category columns to compare, I don't think it would work, and you would need Charticulator or use SVGs in a matrix visual.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you @mahoneypat I've pretty much got it now. I created a test chart using this;
TEAM | MONTH | GOALS |
A | 1 | 10 |
A | 2 | 2 |
A | 3 | 20 |
A | 4 | 15 |
A | 5 | 20 |
B | 1 | 7 |
B | 2 | 12 |
B | 3 | 11 |
B | 4 | 28 |
B | 5 | 13 |
C | 1 | 6 |
C | 2 | 1 |
C | 3 | 0 |
C | 4 | 9 |
C | 5 | 11 |
D | 1 | 17 |
D | 2 | 5 |
D | 3 | 4 |
D | 4 | 16 |
D | 5 | 10 |
I've got it to visualise in the way I want using MAQ Dot Plot but somehow the axes labels have switched round. The x-axis is month but the label says name and vice versa. Do you know what I might be able to do to switch it back?
Hi @DHB ,
Basically it looks like strange. I have created a dot plot chart based on your picture and it gave me the correct corresponding value:
Maybe you can try to re-create a new chart to check or put the fields like this and use drill down to try:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-yingjl I've done that but when I flip orientation to horizontal to put Month on the x-axis the titles don't switch with them. I have to manually overwrite which is fine but not ideal/
Hi @DHB ,
Could you please consider sharing the 'problem' dummy .pbix file for further?
Best Regards,
Community Support Team _ Yingjie Li
It's not letting me upload a pbix but it's the MAQ Dot plot with the dummy data posted above
@v-yingjl It won't let me add a pbix file but it's basically just the MAQ Bubble chart and I used the test data posted above (20 rows, 3 columns).
This seems weird, but in the format options you can turn on the title and put Month and Team in the title text boxes and those text values will overwrite what is shown.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @DHB,
Use a scatter chart for this.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks @MFelix. The scatter chart won't accept categorical data in the y-axis. The only way I could make it work was by giving each category a number but then you lose the category values on the axis.
Hi @DHB
Please Check the sample outcome, i purposed couple of days back:
at least in power BI you can achieve something like this-
Hope this helps
Cheers,
-Namish B
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |