Forum Discussion

Huseyin's avatar
Huseyin
Regular Visitor
9 years ago

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

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 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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