Forum Discussion

abhitiwa's avatar
abhitiwa
Helper I
9 years ago
Solved

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
  • MFelix's avatar
    MFelix
    9 years ago

    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's avatar
abhitiwa
Helper I
9 years ago

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's avatar
MFelix
Super User
9 years ago

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