Insert Gap/space in-between clustered column chart in power BI apps/services report

[roniedhaka]

dear all, i need help. I am using apps.powerbi.com and create a dashboard reprt by importing an excel database file.

Now, while creating a clutered columns chart into the report, i need spaces or gap in-between clustured columns. I have Q1/Q2/Q3/Q4 data and each quarter has order/sales/margin values for items. When i insert columns, these 12 columns clustured together. I need 4 groups of clustered columns and each cluter should have 3 columns- order, sales, margin. How to do it?

[v-juanli-msft · Accepted solution]

Hi @roniedhaka 

Does your data look like this:

Q1 order	Q1 sales	Q1 margin	Q2 order	Q2 sales	Q2 margin	Q3 order	Q3 sales	Q3 margin	Q4 order	Q4 sales	Q4 margin
1	2	3	4	5	6	7	8	9	10	11	12
2	3	4	4	4	4	4	4	4	4	4	4
3	4	5	5	5	5	5	5	5	5	5	5

But you want to show as below

If so, you need to use Power BI Desktop, after connecting to data source, open the Edit Queries, look into my steps applied.

If not, please let me know more about your data structure and desired output.

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.