Forum Discussion
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 value of 1.000,000 , then what I want is the difference between bar 1 and bar 2 and add this difference to the funnel chart
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.
1 Reply
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.