cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Quantity to Value Visualition

Hi,
I'm struggle to find creative way to visualise my sales.
Let's say I have product A, B, C.

Product A cost $1 000. Monthly, I sell aproximately 50 pieces.
Product B cost $ 200 . Monthly, I sell approximately 70 pieces.

Product C cost $ 18. Monthly, I sell approximately 3000 pieces.

 

Now, because Quantity of product C are so high, they ruin all my visualizations.

My questions is, if there exist any visualizations(maybe from marketplace) to deal with it?  (compare QTY to Values)
image.pngimage.png

 

First chart shows Value, second chart shows Quantity.

Red shows product A, black - product B, grey - product C.

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Quantity to Value Visualition

Perhaps try creating a ratio.

 

All Sales = Product A Sales * Product A Price + Product B Sales * Product B Price + Product C Sales * Product C Price

 

Ratio = Product Sales / All Sales

 

Hard to be more specific: Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Quantity to Value Visualition

Hi @pawelj795 

You can create visuals like this:

Capture15.JPG

If this is not helpful, you can show what kind visual you want.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors