Forum Discussion

RichJW's avatar
RichJW
Helper III
7 years ago
Solved

Column Chart Multiple Columns

Hi,   Sorry, quite new with Power BI and sometimes the simplest things in Excel aren't simple in here (to me anyway)!   I wish to create a column chart with 5 separate pieces of data from a datas...
Need Help
  • RichJW's avatar
    RichJW
    7 years ago

    Ah, okay. Many thanks Daniel.

     

    I'll submit this.

     

    Cheers,

    Rich

affan's avatar
affan
Solution Sage
7 years ago

Hi RichJW

 

Can you share some base data so I can help you on this visual

 

Regards

Affan

RichJW's avatar
RichJW
Helper III
7 years ago

Hi Affan,

 

Appreciate the support.

As you will see, it is stacking my columns (this is the stacked chart though), whereas I want the 5 columns to be individually named and categorised.

Thanks, Rich

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    What do you have at the X-Axis?

    • RichJW's avatar
      RichJW
      Helper III
      7 years ago

      The x axis needs to be the 5 fields, whilst the y is the £value.

      As you see from the screenshot, you don't get the option to choose an axis.