Stacked Column Chart - how to stack incremental values

[tk0501]

Hello PBI Community,

I have three measures (called min, expected, max) that are dynamically calculated based on the slicer selections. 

1. Min
2. Expected
3. Max

I am trying to display them via a stacked column chart (min at the bottom and max on the top).

The measure computes the absolute values for each, not incremental values.

For example...

Min = 1

Expected = 5

Max = 9

The stacked column needs to be 9, not 15 (1+5+9). 

I could write a longer measure to calculate Expected-Min instead of Expected value itself. 

However, each measure has complex calculations and takes time to perform. 

Is there a way to tell PBI to stack 1,5,9 to add up to 9, instead of 15?

In another word, do I have to write a measure each time to computer incremental value? 

Thank you

[Icey]

Hi @tk0501 ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey

[Icey · Accepted solution]

Hi @tk0501 ,

You can use Line and Stacked Column Chart instead. Steps are as follows:

1. Create a Line and Stacked Column Chart and change the 'Stroke width' of 'Shape' to 0.

  

2. Make 'Show secondary' and 'Align zeros' on.

3. Change 'Position' of 'Y-Axis(Column)' to Right and 'Color' to White.

4. Change 'Position' of 'Y-Axis(Line)' to Left and 'Color' to Black.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.