Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Waterfall Chart using different Measures

Hi All,

I'm looking for a solution in Waterfall chart. I have different measures to display in waterfall chart which is easy in excel sheet to do with recomeded charts. Is there any solution for this in Power BI desktop?

 

Regards,

Ajay Emmadi

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Please see the attached file with the solution.

     

    For this solution, I have used the sample provided in this post you might have to create UnpivotedTable table manually and follow it be creating Measure like below.

     

    Measure = 
SWITCH(
    SELECTEDVALUE( 'UnpivotedTable'[Index] ),
    0, [PY Purchase Value],
    1, [Volume Variance],
    2, [Mix Variance],
    3, [Price Variance],
    4, [CY Purchase Value] 
)

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Please see the attached file with the solution.

     

    For this solution, I have used the sample provided in this post you might have to create UnpivotedTable table manually and follow it be creating Measure like below.

     

    Measure = 
SWITCH(
    SELECTEDVALUE( 'UnpivotedTable'[Index] ),
    0, [PY Purchase Value],
    1, [Volume Variance],
    2, [Mix Variance],
    3, [Price Variance],
    4, [CY Purchase Value] 
)

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.
    • rtneupane's avatar
      rtneupane
      Frequent Visitor
      6 years ago

      How can we set the beginning and end value as total and different in color from other bars?

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Hi Anonymous ,

     

    Instead of whater fall chart you can also try Funnel chart with more than one measures.

     

    Thanks!