Column Chart Multiple Columns

[RichJW]

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

[affan]

Hi @RichJW

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

Regards

Affan

[RichJW]

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]

What do you have at the X-Axis?

[RichJW]

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.

[v-danhe-msft]

Hi @RichJW,

Based on my test, I am afraid you could not achiveve this feature currently, I suggest you submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He

[RichJW · Accepted solution]

Ah, okay. Many thanks Daniel.

I'll submit this.

Cheers,

Rich

[Anonymous]

Hi @RichJW I have a similar issue, you could try a funnel plot as that accepts plotting multiple values. 

Personally I'd prefer this to be available on a column/stacked bar chart rather than seeing the bars centralised in a funnel plot though.. Do you have the link for the idea post you submitted?