7 Replies Latest reply on Feb 17, 2014 8:56 PM by pradeepbangarusamy

# Display measure values on top of bar chart

I have a report which contain one dimension and two measure. I am using bar chart to display both the measure data like below

I like to display the % on top of the each bar .

if you see the first bar then I have my first measure value is 38 and second measure value is 452 now like to display 38/452 = 8.41%

am not sure this is possible in tableau. if any one have example then please help me.

• ###### 1. Re: Display measure values on top of bar chart

How about a dual axis with multiple mark types, like in the attached?

• ###### 2. Re: Display measure values on top of bar chart

I have a swap measure in place for my first measure that's why when I try to create the position then it's not working

position  = countD(valueZ)-countd(ValueX)/2-countD(ValueX)

• ###### 3. Re: Display measure values on top of bar chart

I have a swap measure in place for my first measure that's why when I try to create the position then it's not working

position  = countD(valueZ)-countd(ValueX)/2-countD(ValueX)

is it possible to sort the bar using % highest to lowest?

• ###### 4. Re: Display measure values on top of bar chart

If you have a swap measure parameter then it needs to control the measure calc and the position calc.

Percentage:

if [Swamp Measure] = 'Profit' then sum([Profit])/sum([Sales]) else sum([Shipping Cost])/sum([Sales]) end

FirstMeasureCalc:

if [SwapMeasure] = 'Profit' then [Profit] else [Shipping Cost] end

Position Calc:

sum([Sales])/5 + sum([FirstMeasureCalc])

1 of 1 people found this helpful
• ###### 5. Re: Display measure values on top of bar chart

Hi Aaron,

Can you share your workbook?  how did you sorted by %.?

• ###### 6. Re: Display measure values on top of bar chart

How to display values on line chart??