Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |