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, ...
Need Help
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Setting the X-axis to Categorical should help you.

     

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