Hi Wanted to show an additional item in a bar popup using an expression without the "Bar" ticked but with a set "Text as Pop-up". Value appeared in popup without label (dispite providing a label value with the expression) but I found a discussion item that told to add the Label into the expression e.g. ='Label = ' & sum(value) With this I lost the number format set in the Numbers section for the expression (which I can understand as I do not provide a number as value). Tried to format the number myself using ='Label = ' & num(sum(value),'#''##0') // note: 2 single quotes in single quoted #''##0
Now I get the number formatted as : 54'3'210 which looks to me like unexpected??
In addition, had quite a few fights with bar charting and the limited options with providing a COOL Popup window. Using the first expression for dimension limit only I lost formatting on Y-Axis. Getting that in place again by ticking "Value on Data Points" I ended up with a mismatch in bar color and legend color by not using first expression as a bar value (solved paritially by assigning background color to the expressions, partially because I have now static colors on expressions and dimension groups won't work as before). Thanks for more help, Juerg
