Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two dimensions, one as week, second as Name for a stacked bar chart.
I have one expression = count (distinct ID)
I want to display total of the count on axis.
I am getting multiple totals as its stacked.
Is there a way to get one single total of all the count
See attached picture. Where I have Date and Material as dimension and my expression is Sum([Stock-level]).
To get the grand total you need to add total <Date> to the new expression, Sum(TOTAL<Date>[Stock-level]). This will result in grand total per date (in your case week).
Thanks.
I want them displayed on "Text on Axis".