Forum Discussion
Need help in creating a report
Hello Experts,
Hope everyone is doing good.
I have a requriement to create a visualization as explained below.
Here is my sample dummy data:
| Category | Project | Budget |
| ABC | P1 | 100 |
| DEF | P2 | 200 |
| GHI | P3 | 400 |
| ABC | P4 | 350 |
| ABC | P5 | 500 |
| DEF | P6 | 150 |
| GHI | P7 | 280 |
| GHI | P8 | 600 |
| GHI | P9 | 360 |
| DEF | P10 | 800 |
I want to create a visualization as shown below:
Expectation: In X-axis display categories and Y-axis display Budget and each project is displayed as bubble where size is proportional to budget. A representational image is attached in the reply section for reference.
Question 2: Is it possible to plot this kind of visualization in excel?
I would appreciate your response.
Thanks in advance.
Hi Anonymous ,
How about creating a R visual?
library(ggplot2) ggplot(dataset,aes(x=Project, y=Budget,col=Project))+ geom_point() + facet_grid(~Category)BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
Anonymous , I doubt this kind of visual -
refer - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
Other you have
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381703?src=office&tab=Overview
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380762?tab=Overview
https://blog.pragmaticworks.com/power-bi-custom-visuals-enhanced-scatter
- Icey
Community Support
Hi Anonymous ,
How about creating a R visual?
library(ggplot2) ggplot(dataset,aes(x=Project, y=Budget,col=Project))+ geom_point() + facet_grid(~Category)BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
