topic Line Chart Incorrectly Sorting Month (x-axis) to show data with 0% before following the sort express in App Development

Line Chart Incorrectly Sorting Month (x-axis) to show data with 0% before following the sort express

boninomolly — Wed, 04 Sep 2019 14:19:46 GMT

I have a line chart with 3 legends : FY18,FY19, FY20. See below. I have the sort expression as : Match([Month], 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan','Feb','Mar', 'Apr', 'May','Jun')

The issue is that when I select a slicer and look at particular cuts, data that is 0% will show up before the model follows the set sort order expression. Below: Jan and October are showing up first.... Any insight? I have tried switching continuous axis to off. No luck with this. Thanks in advance.

Re: Line Chart Incorrectly Sorting Month (x-axis) to show data with 0% before following the sort exp

Yoshidaqlik — Thu, 05 Sep 2019 10:43:58 GMT

Hi,

the expression seems to be correct

try in the script to create a field that is number something like num # (month (date))

Since it has more than one dimension on the X axis, it is perhaps this sort order that is interfering

regards

Re: Line Chart Incorrectly Sorting Month (x-axis) to show data with 0% before following the sort exp

anushree1 — Thu, 05 Sep 2019 11:12:26 GMT

A sample application would help in understanding the issue better