cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GD61 Member
Member

Settings of X Axis in Clustered Column chart

Hi,

The following graph is close to what I need but I have an issue about the X Axis which represents the 12 months of the year(s)

 

 

Almost what I need.jpg

It displays one month out of two: if I display every month (Type = Category instead of Continuous) the months are sorted by decreasing Amount.

If I replace the numbers by the month name (Month_Txt) the months are once again sorted by decreasing Amount.

The sorting of Month_Txt according to Month_Num doesn’t work: the months are still sorted by decreasing Amount.

What I did wrong? My example file is here:

 

https://www.dropbox.com/s/cd42gf98q42jmkq/Clustered%20Column%20Chart%20Month%20on%20Axis%20Year%20on...

 

Thanks for your help

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Moderator v-sihou-msft
Moderator

Re: Settings of X Axis in Clustered Column chart

Hi GD61,

 

To make your chart sorted by Month_Num but keep Month_Txt on Axis. Please follow steps below:

 

1. Insert the Month_Txt into Axis, clear Month_Num. Then you will see your chart sorted by Amount in descreasing order.

 

2. Now you go the Sory By drop down unselect Amount, see screenshot below:

 

44.PNG

After that you chart will sorted by Month_Num as you expected.

 

55.PNG

 

I also attach the modified .pbix file.

View solution in original post

maracles Member
Member

Re: Settings of X Axis in Clustered Column chart

@v-sihou-msft's answer is I think what you are looking for, however I would also recommend that you investigate date tables if you are not already using them. 

There are various links below on different ways of doing it e.g. creating your own, generating it with DAX, downloading one from the data store etc. There are numerous benefits one being that you can create customer date columns which act as labels for your charts eg. (01) - Jan, (02) - Feb. This works particularly well for our business as our fiscal year is not the same as the calendar year. 

Links:

http://kohera.be/blog/business-intelligence/how-to-create-a-date-table-in-power-bi-in-2-simple-steps...
http://www.powerpivotpro.com/2014/02/the-ultimate-date-tablerevisited/
http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/


 

View solution in original post

5 REPLIES 5
mihart Member
Member

Re: Settings of X Axis in Clustered Column chart

Hi,

If you change Month_Num to Month-Txt and then Sort by Month-Txt, it works fine. 

 

click the ellipses in the top right corner, select Sort by and choose Month_Txt.  If you need to change the sort order, click the ellipses again and click the AZ arrow to change it to Jan....Dec.

 

HTH,

Michele

 

Highlighted
Moderator v-sihou-msft
Moderator

Re: Settings of X Axis in Clustered Column chart

Hi GD61,

 

To make your chart sorted by Month_Num but keep Month_Txt on Axis. Please follow steps below:

 

1. Insert the Month_Txt into Axis, clear Month_Num. Then you will see your chart sorted by Amount in descreasing order.

 

2. Now you go the Sory By drop down unselect Amount, see screenshot below:

 

44.PNG

After that you chart will sorted by Month_Num as you expected.

 

55.PNG

 

I also attach the modified .pbix file.

View solution in original post

maracles Member
Member

Re: Settings of X Axis in Clustered Column chart

@v-sihou-msft's answer is I think what you are looking for, however I would also recommend that you investigate date tables if you are not already using them. 

There are various links below on different ways of doing it e.g. creating your own, generating it with DAX, downloading one from the data store etc. There are numerous benefits one being that you can create customer date columns which act as labels for your charts eg. (01) - Jan, (02) - Feb. This works particularly well for our business as our fiscal year is not the same as the calendar year. 

Links:

http://kohera.be/blog/business-intelligence/how-to-create-a-date-table-in-power-bi-in-2-simple-steps...
http://www.powerpivotpro.com/2014/02/the-ultimate-date-tablerevisited/
http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/


 

View solution in original post

GD61 Member
Member

Re: Settings of X Axis in Clustered Column chart

@v-sihou-msft

Great! That works !

Thanks a lot

 

GD61 Member
Member

Re: Settings of X Axis in Clustered Column chart

Hello,

I'll try, Thanks a lot

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 44 members 956 guests
Please welcome our newest community members: