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 dataset.

So, I have Fields named: - Budget, Cost at completion, cost to complete, cost to date, Variance.

 

I wish the column chart to show these as 5 separate columns with a gap in-between. Whenever I try, I am either getting them stacked on top of one another (using the stacked version, obviously), or right next to each other (using the clustered), without the headings/titles below.

I realise it is probably something I am missing, but what?

 

Many thanks,

Rich

  • RichJW's avatar
    RichJW
    7 years ago

    Ah, okay. Many thanks Daniel.

     

    I'll submit this.

     

    Cheers,

    Rich

7 Replies

  • affan's avatar
    affan
    Solution Sage

    Hi RichJW

     

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

     

    Regards

    Affan

    • RichJW's avatar
      RichJW
      Helper III

      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

        What do you have at the X-Axis?