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! Learn more

Reply
Anonymous
Not applicable

Need help

Hello! I am newer to PowerBI and trying to re create a chart I have created in Excel. I want there to be two items in the x-axis. 

To further explain, I want the x-axis to be split into quarters but ALSO by region. So i want on the far left to show Q1-21 AMS and Q1-22 AMS, then i want there to be Q1-21 APJ and Q1-22 APJ, and so on. I hope this makes sense. I just need the x axis to not be sorted by just quarter, but my region too, and I can't figure out how best to go about that. 

I appreciate any insight with this, thank you!

1 ACCEPTED SOLUTION
PC2790
Community Champion
Community Champion

Hello @Anonymous ,

 

Can you try adding the two fields in the X-axis section of Visualization pane as shown:

PC2790_0-1660020510908.png

and then click on the highlighted button shown in the screenshot below:

PC2790_1-1660020638306.png

The end result would be like:

PC2790_2-1660020661413.png

Is this something that you are looking for?

 

View solution in original post

2 REPLIES 2
PC2790
Community Champion
Community Champion

Hello @Anonymous ,

 

Can you try adding the two fields in the X-axis section of Visualization pane as shown:

PC2790_0-1660020510908.png

and then click on the highlighted button shown in the screenshot below:

PC2790_1-1660020638306.png

The end result would be like:

PC2790_2-1660020661413.png

Is this something that you are looking for?

 

Anonymous
Not applicable

Thank you so much, that is exactly what I needed!! I appreciate your quick and detailed help!

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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