Need help in creating a report

[Pratz203]

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.

[Icey · Accepted solution]

Hi @Pratz203 ,

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.

[Pratz203]

Attaching the expected visuaization

[Anonymous]

try the following set up

I realised I made a mistake, the setup should be 
Legend = Category
X-Axis = Project
y Axis =  Budget
Size = Budget 

[amitchandak]

@Pratz203 , 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