Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
What do you have at the X-Axis?
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.
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
Ah, okay. Many thanks Daniel.
I'll submit this.
Cheers,
Rich
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?
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |