Forum Discussion

J_Glees's avatar
J_Glees
Frequent Visitor
4 years ago
Solved

Line and Clustered Column Chart - No Longer Able To Sort By Line Value

Hello,

 

I have a pareto chart I have made which is quite complex. The end result hangs on the ability to sort by the line value which was working fine untill today (17 Nov 2021) in the published report. 

 

I can see the difference between the desktop version, which does what I need, and the published version which no longer has the option:

 

Desktop option has "Sort By" and the three options: Shared Axis, Column Value, Line Value. In this scenario i need to sort by the line value.

 

PuPublished web versionDesktop versionblished version has the "sort axis" option but i'm only presented with the shared axis and the column values, not the line values. 

 

Note this published report has only just changed (unable to sort by line value) in this way so i am wondering if it's to do with the Nov 2021 update - it was working perfectly when last viewed on Monday. 

 

I have DAX queries which handle the calculation for the Pareto chart, specifically creating a pareto chart whenthe column values are the same. 

 

Thanks to anyone who might be able to help.

2 Replies