Skip to Content
avatar image
Former Member

Waterfall chart with multi measures

Hi,

We are in BI 4.1 SP5.

I need to build waterfall chart.

Currently i have data in following format

Month Measure1 Measure2 Measure3 Measure 4 Measure 5 Jan 50 52 -20 30 90 Feb 24 45 -10 20 80 Mar 60 34 -15 45 77

I need to have waterfall chart for each month

Since waterfall chart is allowing 1 measure, I am not able to build it.

Please advise how to build the waterfall chart in webi

Regards

Ben

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 18, 2016 at 09:51 AM

    Hello Ben,

    As far as I know Waterfall chart will accept only one measure. Can you make use of Stacked bar chart instead?

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ben,

      Just so you know, if you see the image I've in my post, there is an overlap between Measure 2, Measure 3 and Measure 4 which is not how a Waterfall Chart should work. The reason for that overlap is because the sample data you provided has Negative (-ve) values for Measure 3 and hence the bar goes down instead of going up.

      Make sense?


      Thanks,

      Mahboob Mohammed

  • avatar image
    Former Member
    Apr 18, 2016 at 07:02 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ben,

      I don't see an excel attached, please attach a notepad file with the data or just attach the whole table with data as you did in your initial post, we'll be able to copy it.

      I've an idea, will try that and let you know if that works.


      Thanks,

      Mahboob Mohammed