Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a custom pop-up label for one expression value in a pie chart. The example below is what I am trying to create:
"There are " & Expression1 " cards that generate a yearly cost of " & (Expression1 * 12), $#,##0
How can I do this?
Hey Cliff,
There is a work around to achieve this. Attaching a sample qvw for you.
Steps to reproduce my solution:
1. Create initial expression: Expr1
2. Turn off Values on data points & text as pop up for Expr1
3. In Presentation tab turn off Pop-up labels
4. Add new Expression Expr2, with your custom pop up definition:
='There are ' & Num(Expr1,'# ##0') & ' cards that generate a yearly cost of ' & Num(Expr1 * 12,'# ##0')
5. Make sure "Text as Pop-up is turned on.
Result:
BR,
Kuba