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
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 Madison Power BI User Group.
1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

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
Employee
Employee

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.

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 Madison Power BI User Group.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.