Reply
Frequent Visitor
Posts: 9
Registered: ‎04-21-2017
Accepted Solution

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


Accepted Solutions
Highlighted
New Contributor
Posts: 497
Registered: ‎09-19-2016

Re: Stacked Column chart - new vs existing

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

View solution in original post


All Replies
Highlighted
New Contributor
Posts: 497
Registered: ‎09-19-2016

Re: Stacked Column chart - new vs existing

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

Frequent Visitor
Posts: 9
Registered: ‎04-21-2017

Re: Stacked Column chart - new vs existing

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 Smiley Happy

New Contributor
Posts: 497
Registered: ‎09-19-2016

Re: Stacked Column chart - new vs existing

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