Ideas Please! Comparing Customer vs Market

[lordtopcat]

Hi Guys,

In my business we ship product to different markets around the world. We have Asia, UK, Europe etc etc..

What I would like to visualize, is how much of the market does "Customer A" have vs the market volume.

I haven't figured out the best way to visulize this ... any ideas would be great!!

Cheers,

Jamie

[v-yulgu-msft · Accepted solution]

Hi @lordtopcat,

I created a sample table based on assumption.

Then, I created a measure to calculate the total sales per product per market.

Sum =
CALCULATE (
    SUM ( 'Customer vs Market'[Amount] ),
    ALLEXCEPT (
        'Customer vs Market',
        'Customer vs Market'[Market],
        'Customer vs Market'[Product]
    )
)

Best regards,

Yuliana Gu

[Phil_Seamark]

Bullet charts and/or bar charts are both good ways to show proportion.  Try out treemaps and see if they work for you. 

[lordtopcat]

Cheers Phil.

I'm not the best at explaining what my brain wants to do - but essentially I need the data to be on one chart.

So, let's take China, and Customer A as an example.

We sold 1000 Bananas to China, and of that Customer A had 650.

I'd like to compare these two on one chart, if that is possible. A combo chart would be great, with the market as the bar, and the customer as the line - but this doesn't seem to work.

Is this possible? Currently I have two charts side by side, but ideally on one would be great.

Cheers