Stacked chart issue

[vjnvinod]

Dear all,

when i created the chart in excel i get the below output in 1 stacked chart

and when i have to load the data into power Bi and create the same stack chart, i had to create 2 stacked chart, see below pic

and below is how dataset looks like

is there anway with the below dataset, we can arrive a stack chart which shows in my excel?

[amitchandak]

@vjnvinod , have taken correct value on-axis and legend

refer

https://powerbi.tips/2019/11/stacked-bar-chart/

[vjnvinod]

@amitchandak 

i don't have anything to place on axis, for instance these are coming as values only

is there a way to sort that?

[SarikaB]

Hey, Select the (Ch2 GCSPs and MSL's) and keep that in Axis Fields of the Stacked Column Chart and all the other columns to the values.

[vjnvinod]

@SarikaB 

i can't do that as  don't have(Ch2 GCSP and MSL  as coloumn) but i have their numbers