How to create a waterfall graph while comparing the data to previous month and this month

[Huseyin]

Hi,

I do have 2 long list in excel. There are unique ID for each of the item

I need to compare the items (this month vs previous month) and need to find what ites have been added what items have been dropped. Then create the waterfall as below

The amount of items in previous month -->new added ones-->dropped ones-- The amount of the current mont

Thanks for the support

Huseyin 

[v-shex-msft]

Hi @Huseyin,

Current waterfall visual not support multiple y axis, perhaps you can post this requirement to ideas.

>>The amount of items in previous month -->new added ones-->dropped ones-- The amount of the current mont

I don't think power bi can anto analysis these amounts, you should manually calculate them.

Regards,

Xiaoxin Sheng