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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
saipawar
Helper IV
Helper IV

remove gap between clustered column chart

saipawar_0-1636569311506.png

Hi

How can I club X asix values? I would like to have a single "Events" and "Paid Media Campaign" text on X asix with 2 column bars for each text

 

Here's a table view - 

saipawar_0-1636571230350.png

 

How can I combine these 2 (Events and Campaign) into single line items?

 

Thanks

8 REPLIES 8
mhossain
Solution Sage
Solution Sage

@saipawar 

 

Please share the dummy pbix with same structure.

Please use this dummy file on Google Drive

Hi @saipawar 

Data looks in good format already, can you share the dummy pbix file where you are having axis issue.

Looks like there is a special character (?) at the end of 'Plan' items. Is there a way to remove those? I have trimmed and cleaned that data column but still getting the same error. 

 

Thanks

Hi, @saipawar 

You can replace the special character (?) with “” to  trim and clean the data colum.

5.png

If I understand correctly, you can try  'new group' to combine 'Events' and 'Paid Medium Campaigns'. Then replace the original field "status" with this "new group" field in the matrix legend.

 

6.png

 

Best Regards,
Community Support Team _ Eason

 

Greg_Deckler
Super User
Super User

@saipawar Use a stacked column chart? Or create a measure that combines Actual and Plan?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler Even a stacked column chart is giving me two separate bars for each Sub Function!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors