Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.