Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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