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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
admin_xlsior
Post Prodigy
Post Prodigy

Line & stack chart : X axis value

Hi,

 

I'm using Line and Stacked Chart for my data with dates progress (Year - Quarter - Month) in a hierarchy style.

 

admin_xlsior_1-1645427770962.png     admin_xlsior_0-1645427738587.png

 

Question is, can the Axis value grouped together, like this ->

admin_xlsior_2-1645428253265.png

Please ignore the color, I only want to show what I expected which is group the year and quarter to only appear 1, just like the column header hierarchy in Matrix visual

 

Thanks

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@admin_xlsior , Sort on axis column, and use concatenate label - off, see if that works

 

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

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

2 REPLIES 2
Anonymous
Not applicable

Hi @admin_xlsior 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@admin_xlsior , Sort on axis column, and use concatenate label - off, see if that works

 

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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