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.
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.
Solved! Go to 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.
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.
Attaching the expected visuaization
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
@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
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |