Forum Discussion
Spacing between bars for clustered column chart that used measures only in y axis.
Hi Anonymous
You can't modify the space between the bars, because the graph doesn't have X-axis. it is jest a set of measures that you put there.
To resolve this issue you can create a measures table and use a dynamic measure to get a bar for every measure.
For example, in my data, I want to create a graph like yours with Chinese sales and total sales.
The first step is to create a table of wanted measures :Then you can create a dynamic measure using switch
dynamic measure = SWITCH(SELECTEDVALUE('sales table'[sales type]), "chineese sales",[Chineese_sales],"total sales",[total_sales])After you have a table and a dynamic measure you can use a graph in its natural way :
the pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
In Power BI, the clustered column chart might not allow you to manually adjust the spacing between individual bars directly. However, you can simulate spacing by adding dummy measures with null or zero values between your actual data measures. This approach requires creating additional calculated measures that return null or a visual representation of zero and placing them between your actual measures in the chart.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.