Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
roniedhaka
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
v-juanli-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-juanli-msft
Community Support
Community Support

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors