Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Waterfall Chart with Custom Visual / Measures using 3 columns instead of just 1

  Hi,   I am wondering if anyone knows how to create a waterfall chart with date/time being the axis but the values being taken from 3 columns / as they are seperate categories?   I have Total ...
  • v-yingjl's avatar
    6 years ago

    Hi Anonymous ,

    As we know, waterfall charts show a running total as Power BI adds and subtracts values. They're useful for understanding how an initial value (like net income) is affected by a series of positive and negative changes.

    I have tested most types of waterfall charts(waterfall chart, simple waterfall chart and waterfall chart by visual BI) in power bi desktop, but all of them can just meet part of your requirement. None of them can show the value like a ladder as your posted picture because the growth of the next value depends on the previous value not restart as 0.

    For further information about waterfall chart, you can refer the following Microsoft document:

    https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts

     

    Best Regards,

    Yingjie Li

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.