Forum Discussion
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.
- Min
- Expected
- 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
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
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.