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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
lovishsood1
Resolver I
Resolver I

Add spacing on basis of Category in Clustered Colum Chart

Hello Everyone,

 

I'm using Clustered Column chart to show my data of MAX YEAR and MAX YEAR - 5.

Screenshot attached below :

lovishsood1_0-1684606060326.png

 

I have created two measures for this, one for each year.

X-Axis: Country Colum (Table 1)

Y-Axis: Two Measures 

 

Problem: I want to sort the data on the basis of CATEGORY column present in TABLE 2 and after each category I need one space in CHART.


EXPECTED OUTPUT: 

lovishsood1_2-1684606395104.png

I have marked the space with RED ARROWS.


I need to sort the countries on the basis of Category and need space after each category.


IF anybody know, How can I achieve this? Please do tell me.

 

 

Thanks.
I hope my problem is understood.


0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors