cancel
Showing results for
Did you mean:
Frequent Visitor

Stacked Column Chart - how to stack incremental values

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

Re: Stacked Column Chart - how to stack incremental values

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.

2 REPLIES 2
Super Contributor

Re: Stacked Column Chart - how to stack incremental values

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.

Super Contributor

Re: Stacked Column Chart - how to stack incremental values

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

Announcements