cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leonardmurphy
Skilled Sharer
Skilled Sharer

Chart Cannot be Sorted by Axis Field in Ascending Order

Expected Behavior:

  1. In a column or line & stacked column chart, I expect to be able to sort the chart by the axis field in ascending order.

 

Actual Behavior:

  1. By default, the chart sorts by value. If I change to "Sort by [Field Name]" the chart sorts in descending order. However, if I click on "Sort by [Field Name]" again, then the chart reverts back to sorting by value. There is no way to be able to sort by Field Name in ascending order.

How to Reproduce:

  1. I reproduced this in the April 2018 version of PBI Desktop
  2. Create a new column or line/column chart with a measure on Value and a text field on the Axis. E.g. the measure might be 'Executions' and the axis field might be 'Test Name'.
  3. Try to sort the chart by 'Test Name' is ascending order by clicking on the ellipse at the top right on the visual. You cannot. At least I cannot.
---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.
1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft
Microsoft

Hi @leonardmurphy,

 

Actually this is a trick of the button. When you click the option, the option is enabled. If you want to change the order, you need to click the small icon in the head. Please refer to the snapshot below.

Chart_Cannot_be_Sorted_by_Axis_Field_in_Ascending_Order

 

Best Regards,

Dale

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

View solution in original post

4 REPLIES 4
v-jiascu-msft
Microsoft
Microsoft

Hi @leonardmurphy,

 

Actually this is a trick of the button. When you click the option, the option is enabled. If you want to change the order, you need to click the small icon in the head. Please refer to the snapshot below.

Chart_Cannot_be_Sorted_by_Axis_Field_in_Ascending_Order

 

Best Regards,

Dale

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

View solution in original post

Capture.jpg

Mine only can show descending order, how to change it to ascending order in the menu?

Hi @Tze,

 

Click on the icon in the head (ZA and down arrow) exactly. Please refer to the snapshot of my post.

 

Best Regards,

Dale

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

Subtle, but that was the problem. I must have been clicking on the words rather than the icon at the beginning. Thank you.

---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.