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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nh131215
New Member

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 @nh131215 ,

 

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 @nh131215 ,

 

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?

 

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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