Sorting on Null value Dates

[shyamcharan]

Hi Experts,

I do have a chart with Date Dimension Drill Down with Month and Year from Fiscal Year. Also, the Operational Assets and the Activity Cost included.

For certain dates there are no values for Asset and Activity Cost. I have forced the graph to show all the months regardless of the data values. But I am trying to sort the months with the Fiscal Month column order. However it does not work and I believe it is because of the Null values as shown in the Table on the right hand side.

Can someone please help sort the months on X-axis as per fiscal year order(eg: July2014  to June2015). I guess this is sorting on null values. How can I meet my requirement.

Regards,

Shyam.

[tresesco · Accepted solution]

Sort expression: =Only({1}ReportingDateDim.FiscalMonth)

[shyamcharan]

Thank you very much Tresesco. That fixed my issue. Cheers.

Regards,

Shyam.

[shyamcharan]

Hi Tresesco,

Just wondering why I do see the graph below the Zero line though the Cost is never negative.

Appreciate if anyone could help me understand this behaviour.

Thanks in advance.

Regards,

Shyam.

[tresesco]

Because your line type is chosen 'Smooth' (Display options) in the expression tab, and your data points are months, so to move from one month to another qv chose to go smooth and that is in this case down the line. Otherwise, if you see the end points(months - Feb and Mar are rightly pointing to 0). If you choose the line type as 'Normal', you will see the change.

[shyamcharan]

That makes sense to me now. Thanks heaps Tresesco.

Appreciate a lot for your help.

Regards,

Shyam.