Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I limit the number of displayed values in popup labels? I created a continuous line chat with over 100,000 values on the X axis. I turned off "Pop-up Labels" in "Presentation" tab and also created an expression for the information displayed, but still fail to limit the list to a single value. I tried to use min or max but did not work.
Hi,
You can try left() function.
Rebeca
Hi,
Left() function helps me to limit the number of decimal places, but not the number of rows in pop-up label. It is true that reducing the number of decimal places is reducing and the number of rows displayed, but it is still greater than 1.
My goal is to display a single row in pop-ups. Instead of Left() function I used Num()
= 'Sellers: ' & Num((PR_Rank / vCountSellers) ,'#.##0,0%')
Could you post your exact expression?
Looks like it is the nature of continuous combined with pop-up labels.
This is a little trick that might help you.
Untick pop-up labels in expressions for the expression you already have. Create a new expression in the charts expression tab with the text and expression you like, example =’The text’&sum([The number])
For the same expression you deselect line/bar/symbol as display option but instead select text as pop-up.
You basically create a separe expression that is not shown as a line/bar/symbol, but only as a pop-up.
Hope its helpful.
Slick trick!! I wish I knew this long before. Is that the only way to format the Pop-Up Tool Tip?