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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Combine Year instead of repeating year in table axis

Hi all, 

I currently have table x-axis as below which show repeating year through two column "year" and "monthnameshort; 

 

qhpowerbi_0-1664762591053.png


How can I make the year is combine like example below?

qhpowerbi_1-1664762672815.png

 



1 ACCEPTED SOLUTION

@Anonymous , Concatenate Label off, Sort on Axis

 

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

 

From Sep 2022 onward that should be the default, but if does not work by default, use the option.

 

It should work for column Bar

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , Use Year and then Month then expand then the year will not repeat

 

amitchandak_0-1664763181199.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak 

Its not happen...below is my x axis column

qhpowerbi_0-1664763187165.png

 

qhpowerbi_1-1664763201179.png

 

qhpowerbi_2-1664763214783.png

 



@Anonymous , Concatenate Label off, Sort on Axis

 

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

 

From Sep 2022 onward that should be the default, but if does not work by default, use the option.

 

It should work for column Bar

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak ,

 

Its work! Million thanks!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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
Top Kudoed Authors