Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Paginated Report Builder Line Chart Showing Displaying Value For Empty Data Points

Hi All,

 

I am using the new paginated report builder and wonder if anyone knows how does the line chart handles empty values in the data?

My line chart has a region where we don't have any data, so ideally it should just go to zero/show an empty space. However, it is connecting the two adjacent data points and create a line as if it changes constantly over that period of time. See attached.

Thanks in advance,

JC

Need Help
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Forgot to add that I have googled this and tried several ways people suggested, including:

    - Changing the value of the series to an expression where it shows 0/nothing if it IsNothing

    - Changing the color of the series using an expression where it shows no colour if value of the series IsNothing

    - Setting the EmptyPoint Value = Zero and changing the properties of the empty point in the Properties pane. 

     

    None of the above work. Does anyone have a clue?

    • Goofr's avatar
      Goofr
      Icon for Advocate IV rankAdvocate IV
      2 years ago

      Hi,

       

      Dit you found a sloution in Report builder?

      Thanks in advance

       

      Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Setting the X-axis to Categorical should help you.