How to Display Zero's on Line chart

[Anonymous]

Hi All,

I have a line chart which had one Dimension and One expression. The chart is showing last 6 months data for example if I select Mar 2017 it will show Oct 2016 to Mar 2017 Data .According to Month selection it will display last 6 Months Data But the issue is this chart not showing '0' values for example Dec 2016 has value '0' this is not showing in chart. I already unchecked 'Suppress zero's' and checked 'Zeros on bar' but still not getting values. I tried to check 'Show All values' for Dimension but it is showing all years and months values.

Please help me to resolve this its an urgent issue in my project.

Thanks,

Anusha K

[Anil_Babu_Samineni]

May be use Dimension level like Show All Values? Or would share sample

[Anonymous]

I tried 'Show All values' it is showing All years data instead of last 6 months Data. I can't share sample because its a highly secured network.

[Anil_Babu_Samineni]

Atleast Expression? And screen shot may be

[Anonymous]

Dimension: Month_Year

Expression: = Median({<IncidentDate={">=$(=Num(MonthStart(AddMonths(Max(Incident_Date),-5))))<=$(=Num(Max(Incident_Date)))"},Month=,Year=,Impact={'1*','2*','3*'},Urgency={'1*','2*'},Month=,Year=>}[Incident Duration]) * 60

[Anil_Babu_Samineni]

Does IncidentDate is associate to Month_Year? Because, Set analysis you are doing with two diff. Fields. May be use Month_Year instead of IncidentDate.

If so, From my end last chance please share data -- Scrambling Data

[Anonymous]

Both dates are associated with Month_Year Field. If I use Month_Year instead of IncidentDate the result will be same no change in result.