Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I searched it in several post but i didn't found how to solve my problem. Actually, I am not able to display the total of a stacked bar chart, it repetes the result as many times as values of dimensions there are. I want to show just one.
The expression is (It corresponds for the result in gray):
num( | ||
sum(TOTAL <"Periods"> {<[_ContractedProjectFlag]={1}>}[Project volume]) | ||
,$(vU.Format.0D) | ||
) |
Periods: cycle dimension which contains some dimensions relative to dates.
I would appreciate so much any help
Thanks,
On the presentation tab untick Plot Values Inside Segments.
Or you could tick Still Show Total on Top so you get it both by dimension and the total.
Hi Bill,
I want to have both values, by dimension and the total. The problem is whether I tick <Still Show Total on Top>, I do not know how to format this value. I am using variables to be able to transform the numeric format, using num() function and a list box which allows to do the selection of format. What ever, if I put it manually in the number tab, I lose this dynamism.
Some idea to achieve it?
Thank u very much.
What is the number format of your expression, I think your number format should be "Expression default"
I am using a variable which contains calculated dimensions for the first expression (Two option in this case). The same for the second one.
Hi Rupam,
Finally I do it, because I think there is no way to deploy what I want...
As you can see I can format the number in the pop up, but I can not in the graph.
Thank you.
Hi ferchops1987 , could you post the solution, we just migrated to QV12, and suddenly it's repeating the values.
Would like to know how you solve it.
Many thanks
Hi Martin,
I am using Combo Chart, so in the tab Expressions I've chosen "Values on Data Points" and then in the Presentation tab in the "Values on Data Points"...