Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Amber_Dogra
Advocate I
Advocate I

NEEDED volume high low close stock EXCEL chart same in POWER BI

Hi genius community,
One of the team has done the analysis of below table data values pasted in the body - in Excel and has created this one of the stock chart.
I am now looking to create the same Visualization in Power BI, but unfortunately, found nothing close to this. Tried with Candle stick custom visual chart also, but couldn't able to get the desired visual output.


Annotation 2023-04-24 134843.png

Sr No.product listStd UnitPrice per Piece SHELFPrice per Piece ASPPrice per Piece PROMO ASPPrice per Pack SHELFPrice per Pack ASPPrice per Pack PROMO ASP 
1Product 133,873$0.25$0.25 $11.38$11.38  
2Product 232,057$0.44$0.40$0.34$33.63$30.80$26.58 
3Product 318,340$0.48$0.43$0.37$17.78$16.25$13.87 
4Product 47,135$0.49$0.44$0.41$16.14$14.88$13.86 
5Product 56,119$0.45$0.43$0.38$27.53$26.21$23.48 
6Product 64,852$0.58$0.52$0.46$34.62$31.14$27.77 
7Product 71,292$0.50$0.47$0.40$21.79$20.58$17.71 
8Product 8576$0.71$0.65$0.59$25.75$23.76$21.67 
9Product 91$0.69$0.60$0.30$34.95$29.42$13.93 
10Product 101$0.17$0.14$0.10$8.62$7.50$5.81 
11Product 111$0.15$0.15$0.14$10.96$10.86$10.03 
12Product 121$0.27$0.27 $12.26$12.26  
13Product 130$0.42$0.42$0.35$13.91$13.81$12.53 
14Product 140$0.24$0.24 $22.93$22.93  
15Product 150 $0.19$0.19 $8.46$8.46 


Can someone help me to create this kind of visualization in power BI, or what is the name of this visual.

Note: Table data values and desired visual output is pasted in the body. Thanks-in-Advance.

4 REPLIES 4
Amber_Dogra
Advocate I
Advocate I

@amitchandak , @onurbmiguel_ , @lbendlin , @Ahmedx - Hi Authors, please help me in the above query, thanks.

Hi @Amber_Dogra 

My suggestion is that you create a measure for each bubble e use the line and clustered column chart as final visual: 

 

onurbmiguel__0-1682437150108.png

on the lines you will use the new measures and try to set the line as transparent

 

 

Best regards

Bruno Costa | Power Participant

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Hi @onurbmiguel_ 
I agree with your solution. However, I have selected the Stack Column and Line combo chart and used the bubble metrics in Line Y axis and reduced the Stroke width to Zero and specified the required color scheming to Lines.

Amber_Dogra_0-1682491021365.png

This visual is close to the desired visual. But, with just one thing missing - a line connecting these bubbles. Is there any way to incorporate those lines as well in the visual? please let me know @onurbmiguel_ 
For example: as illustrated in the snapshot below -

Amber_Dogra_1-1682491251466.png

 



Hi @Amber_Dogra 

 

Sorry but i´m not seeing any solution for that. 

Maybe a custom visual , maybe Charticulator (but you will need to read some documentation and see some videos) . 

 

 

Best regards

Bruno Costa | Power Participant

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!
 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors