I created a stacked bar chart by stacking two measures. I'd like to label the segments for one measure but not the other. If I was creating a stacked bar chart with a single measure and colouring the segments with a dimension, then it would be easy to selectively show labels. I would just create a conditional field (if [dimension]=X then [measure] end). However, I can't use "Measure Names" in a calculated field. Anyone know a solution?
In the pic below, I'd like to label the blue segments but not the grey ones.
I've attached the workbook.
Thanks for your help!
hi John,
If you set up the labels like so
That should do it.
We are only plotting the MIN Label, and using the Measure Name to determine what is the MIN/MAX based on the order of the measure values ...bit odd and counter-intuitive, but it works!
