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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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