stacked column chart

[Anonymous]

Hi,

I am using the stacked column chart as follow

I placed two fields (Field1, Field2) in value and Field3 into Axis

Field1 value is 3Millions and Field2 is 5Million

At present as standard, Field2 sits over the top of Field1 as a column

For example, Field1 starts from 0M and goes up to 3M in chart, then on top of Field1 value, Field2 starts and goes up a further 5M, i.e. it goes to the 8M y axis. Which is the standard look of stacked column chart.

Question:

I would like Field1 and Field2 to overlap each-other instead of Field2 starting from the tip of Field1

so that both start from 0M. Field1 goes up to 3M as it is now but Field2 value to start from 0M and go up to 5M

I guess what I am after is clustered column chart bu overlapping not next to each other bars for every occurance of teh value in X axis

Hoe you know what i mean.

Thank you

[v-juanli-msft]

Hi @Anonymous 

This is standard look of stacked column chart.

The clustered column chart is possible.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @Anonymous ,

maybe you want to use the custom visual "Bullet Chart by OKViz" from the marketplace, that's available free of charge.

I created this

From the formatting options of the visul I

• switched orientation to vertical, available in the General band
• switched the states to off

Hopefully this is what you are looking for.

Regards,

Tom

[Anonymous]

Hello,

This looks better, however, I would like to have the width of the vertical bars to be the same

thank you