Forum Discussion

abhitiwa's avatar
abhitiwa
Icon for Helper I rankHelper 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

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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
      Icon for Helper I rankHelper 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
        Icon for Super User rankSuper 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