I have a stacked bar chart created using measure values and order date however on labels I want to show a separate field i.e. total sales on top of the bar.
I have tried reference line and dual axis as well.
Attached is the sample workbook.
@Ankit Narula Hi Ankit
I found that you have created a dual axis chart, which resulted in a collection of all the measure values overlapping the primary measure (i.e. [Total Sales]).
The reference line you have created earlier is placing the [Total Sales] figure on top of the individual quarterly bar charts correctly, but it looked like it was not at the top because the [Total Sales] bar chart was in the back, while a combined measure value bar charts were overshadowing it at the front.
A remedy for this is to remove the second axis along with all of the measure values bar charts.
Then using only a single axis with a measure [Total Sales], add a reference line and the correct measure value will be displayed on top of each bars.
I have attached an updated workbook.
I hope this helps.
