Forum Discussion

AaronLS's avatar
AaronLS
Advocate II
10 years ago

Broken Line Charts

Using online report editor against SSAS DM, Line chart has gaps for missing values.  Is there anyway to get the lines to draw down to 0?  I have set "Show items with no data" for the Axis and that di...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

AaronLS

 

Is the type of Month column Text? If yes, you will see the “broken” line chart. I think the only way is to fill the missing values with 0 in your SSAS.

If the type of Month column is Date, you should be able to see the continuous line.

 

Best Regards,

Herbert

AaronLS's avatar
AaronLS
Advocate II
10 years ago

I'm not sure what you mean by "fill the missing values with 0 in your SSAS".  The measures are aggregations of facts, in this case counts of facts, which returns an integer.  The months missing values are months where there is no related fact record for that intersection of values.  If for example, I add some sort of bogus fact record associated to the axi, then the count of records will be 1. So there isn't any record that can be populated with a 0, because it is a count.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    10 years ago

    AaronLS

     

    It seems that the Response Count measure may return BLANK(). What about changing your measure like below?

    Measure = IF ( Count = BLANK(), 0, Count )

    Then if there is no record in one month, the count will be 0 but not BLANK for that month and line chart should not broke any more.

     

    Best Regards,

    Herbert