we can also create such pop ups with using a special expression rather we can use dual() with all the display things as strings and numeric value as the second argument.
dual(
Num(Sum(Spend), '$#,##0.00;$#,##0')&
'
Spend % = '&
Num(Sum(Spend)/Sum(Total Spend), '#,##0.00%')
,
Num(Sum(Spend), '$#,##0.00;$#,##0')
)
This is one such example where I am using in our project , where the bars takes the second argument value for rendering bars and first argument for pop ups.
If you go to the expression and expand it (by clicking on the + Icon) there are a number of additional properties you can set. One is the Offset typically used when creating waterfall charts. Here I have increased the starting point by the Min value which creates this effect.
This has worked for me except there were a couple of things that were not obvious and were different in my chart. I have mine working but maybe I missed something:
1: I have a Line chart with 4 lines. The chart type must be changed to Combo Chart for this to work.
2: The additional expression for the pop-up text showed up in the legend. In your QVW it doesn't. How did you get it to not display it? I had to check Bar and Invisible for it to display in the pop-up and not in the legend.
