cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
roniedhaka Frequent Visitor
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

6.png

 

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.

1 REPLY 1
Community Support Team
Community Support Team

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

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

6.png

 

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.