Forum Discussion

alpa271064's avatar
alpa271064
New Member
2 years ago
Solved

Waterfall Chart from Measures with differences

Hello.  

I am trying to build a chart like this one: 

I have 4 Measures to calculare the 100%, 95,4%, 44,7% and 32,7%. I have created a new table with the names of my measures and build an measure with Switch to get all values in one Measure: 

Display =
SWITCH (
    SELECTEDVALUE ( KategorienTabelle[ID] ),
    1, [Verfügbarkeit],
    2, [Produktivität],
    3, [Qualität],
    4, [OEE]
)
 
When i create the waterfall chart it looks like this. 
 
I want to rebuild it like in the first picture provided. I hope someone can help me out. 
 
Regards
Alpa

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi alpa271064 ,

     

    Thanks for the reply from rajendraongole1 , please allow me to provide another insight: 

     

    You can try Hierarchical Bar Chart.

     

     

     

    Based on your description, I created the measures and put the appropriate fields into the visual object.

    Measure =
SWITCH(SELECTEDVALUE(financials[Discount Band]),
"None", [Measure 1],
"Low", [Measure 2],
"Medium", [Measure 3],
"High", [Measure 4])

     

    It's worth noting that the percentages in the circles show the percentage change in the two data.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi alpa271064 - the first picture is not a waterfall chart, i think it is bar chart with values percentages, 

    one more thing, if you really need to use waterfall chart, hope in your percentages both postives and negatives values should be there. Can you please help here to understand with some sample data and expected output 

     

    if you have 4 measures and want to report the values for each category, then i such scenerio you can use field parameters concept and bring the same as expected. 

     

    it helps us to analyse and share the expected results.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi alpa271064 ,

     

    Thanks for the reply from rajendraongole1 , please allow me to provide another insight: 

     

    You can try Hierarchical Bar Chart.

     

     

     

    Based on your description, I created the measures and put the appropriate fields into the visual object.

    Measure =
SWITCH(SELECTEDVALUE(financials[Discount Band]),
"None", [Measure 1],
"Low", [Measure 2],
"Medium", [Measure 3],
"High", [Measure 4])

     

    It's worth noting that the percentages in the circles show the percentage change in the two data.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.