Showing % of Measure in stacked column chart

[Anonymous]

Hi everyone, 

I have two measures which are just numbers of some Profit. One Measure get´s the maximum of all numbers, the other measure gets the minimum of all numbers. 

I want to display the MIN in % (or just the number)  of the MAX Value in a stacked column. So for example Max is 100 and min is 40.

Y should show 100 and the 40 stacked of it in another color. is this possible? I know i can do this with a secondary-y - but this is not what i want. 

Best Regards, 

deliser

[Anonymous]

@Fowmy 

Hi, yes of course - i want to be able to show it differently - let me explain:

for example Measure1 = 100 and Measure2 = 40 - If i show the two colums it shows me total sum of 140 with both values. Thats not what i want. I want to declare somehow that measure 1 is the maximum - and display measure 2 as percentage from measure 1 ->

Best Regards

[Fowmy · Accepted solution]

@Anonymous 

Please check the attached file

[Fowmy]

@Anonymous 

In an Stacked Column chart, you can add both the measures on the Y axis, have you tried that ?

A sample or a screenshot will help me understand the requirment