stack Column simple merge

[bideveloper555]

hi

i am trying to show a data set which has fixed value and actual value.

fixed value = 100,200

actaul value = 40,60

i want to merge the orange data into blue.just like filling a jug. i can do by stacked percantage but i want number.(values)

[v-eachen-msft · Accepted solution]

Hi @bideveloper555 ,

I am afraid that Power BI doesn't support such a visual. There is a temporary solution:

Create two measures: "sum of series 2" and "sum of series 1 - sum of series 2", then use stacked column chart to show these measures. But series 1 will only show 60 & 140.

Here is the test file for your reference.