cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vjnvinod
Post Prodigy
Post Prodigy

Stacked chart issue

Dear all,

 

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

 

Capture.PNG

 

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

 

Capture1.PNG

 

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?

 

Capture3.PNG

 

4 REPLIES 4
amitchandak
Super User
Super User

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

 

refer

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@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
Regular Visitor

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.

 

StackedChart.JPG

@SarikaB 

 

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!