Stacked Column chart - new vs existing

[abhitiwa]

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

[MFelix · Accepted solution]

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

[abhitiwa]

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 🙂

[MFelix]

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