cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
abhitiwa
Helper I
Helper I

Stacked Column chart - new vs existing

Hi

 

I have a column for Total Orders, and a separate column showing whether is from a New / Existing customer. How do I show it in a stacked chart in PowerBI ?

 

Thanks

Abhishek

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @abhitiwa,

 

Chosse the Total Orders for the Value and the New/Existing for the legend. This will give you different data colors.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

Hi @abhitiwa,

 

Chosse the Total Orders for the Value and the New/Existing for the legend. This will give you different data colors.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks @MFelix. This works. One more thing - Now I have order values in a single bar with diff colors for new and existing. How do I get them to show as a % of total?

 

For eg - in Jan month, I have 2 orders from new, and 8 from existing. How do I show it as 20% and 80% (instead of number values)?

 

Thanks in advance 🙂

Hi @abhitiwa,

 

Choose the 100% Stacked column chart (it th 6th visual in the power BI) and you will get the same but in percentages.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors