Forum Discussion

eMEIPE's avatar
eMEIPE
New Member
2 years ago
Solved

Doubt with funnel graph

Hello everyone, I have a funnel chart where I want to add that for each bar of the chart it generates the difference with the previous bar, for example bar 1 has a value of 2,000,000 and bar 2 has a ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi eMEIPE 

    It cannot put two values to the funnen, you can consider to put the difference to the tooltip.

    e.g 

    Sample data 

    Then creeate a measure and put it the the tooltip of the funnel chart

     

    Difference = var a=CALCULATE(SUM('Table'[Value]),'Table'[Level]=SELECTEDVALUE('Table'[Level])+1)
    return a-SUM('Table'[Value])
    

     

    Output

     

    Best Regards!

    Yolo Zhu

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