Hello PBI Community,
I have three measures (called min, expected, max) that are dynamically calculated based on the slicer selections.
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.
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?
Go to 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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Hi @tk0501 ,
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!