Volume-price-mix variance (VPM, PQM, PVM)

[gm]

Hi All,

I have two datasets including sales volume and revenue data per product per customer per month. I can calculate volume, price and mix variances within the revenue but cannot put those impacts at the same time on a waterfall chart (only one of them at one time or the total revenue variance per brand or customer). Can you please advise how to visualise VPM variance on the same waterfall?

Thanks a lot!

[gm]

Dear @CheenuSing and @v-qiuyu-msft,

I have created a sample which is available here: http://s000.tinyupload.com/?file_id=68552689798873198546 (simple xls file). Let me know if you prefer a different way to share.

This is not built to be dynamic but my chart needs to update when I select group of brands and/or customers (or total company). And later I will add the time dimension: variance per month, YTD, YTG, FY so ideally should be compatible with that as well.

Thanks for your time!

gm

[CheenuSing]

Hi @gm

Couple of questions.

The data you shared is very limited in scope. Can not understand how the different values are arrived at.

Appreciate if you can share the full data model, the expressions you have used to calculate the measures.

Are you doing direc query or import data approach for loading the source data into the model ?

Cheers

CheenuSing

[gm]

Hi @CheenuSing,

I will create a bigger sample but due to christmas I have limited time. Will get back in a few days max.

How can I share such a dataset most effectively?

Thx,

Gabor

[CheenuSing]

Hi @gm

You can share the data in one drive and share the link. Also share the data model, pbix file and expressions used for measures .

Cheers

CheenuSing

[gm]

Hi @CheenuSing & @v-qiuyu-msft

Please check these: http://s000.tinyupload.com/?file_id=44002569142856624791 & http://s000.tinyupload.com/?file_id=56374514096896120691

(my One Drive is restricted)

The volume / price / mix effect charts should be combined into one chart showing V/P/M effects for selected brands and/or customers dynamically (and of course totalling to total sales difference). Any solutions or necessary changes to how to organise data is more than welcome.

Thanks!

[v-qiuyu-msft]

Hi @gm,

I'm not able to access and download the file, would you please upload the files to Dropbox and share the link here?

Best Regards,
Qiuyun Yu

[gm]

HI @v-qiuyu-msft

Here come the links

https://www.dropbox.com/s/uqnw5jgelq0xbev/VPM%20sample.pbix?dl=0

https://www.dropbox.com/s/zhpwaz5u8tosob3/powerbi_sample_database.xlsx?dl=0

Hope this will work.

Cheers,

Gabor

[gm]

Hi All,

Anyone on the above?

Thanks a lot!

[v-qiuyu-msft]

Hi @gm,

It seems that you want to place the volume, price and mix variances in a column then place it in waterfall chart Category property, right?

If that is a case, you can take a look at my post in this thread: Waterfall challenge . It it doesn't meet your requirement, please share some sample data and desired results for our analysis.

Best Regards,
Qiuyun Yu

[CheenuSing]

Hi @gm

Please post some sample data and the actual visual you expect.

Cheers

CheenuSing