How to show multiple Data labels in a Column chart
Hi!
I,m a beginner in SSRS 2008 but i,ve managed to make charts with data labels showing amounts. My problem is that i also would like to show number of items sold in the chart preferably also as a data label or in some other way in the same chart. I would
not like to show units sold in a separate column serie for the units. Is this possible to to in any way?
Best regards
Arne Olsson
Arne Olsson
November 18th, 2011 6:42am
Hi Arne,
What I understood from your post, you want to show 2 fields as Data Labels :
Amount and Items Sold.
I don't think you can create 2 seperate Series Labels for a single measure plotted in the chart.
Either you have to create another Measure in your chart plotting Items Sold.
Or, Show both the fields in a single Series Label. You can do this like:
Right-click Series label.
Click Series Label Properties. Click Label data. Write the custom expression.
Please, let me know if this is what you was looking for.
Regards,
Manoj
*Happy to help
http://experiencingmsbi.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2011 8:57am
Hi Manoj!
Thanks for your help it works perfect.
Best regards
Arne OlssonArne Olsson
November 18th, 2011 10:30am
Hi Manoj.
Thanks for your replay..
Its helped me.
Regards,
Abhishek.B
Free Windows Admin Tool Kit Click here and download it now
April 10th, 2012 12:46pm