Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Hello Everyone,

I found lot of queries being asked that Charts not displaying properly when have null values against then in the measure values. So thought of sharing my past experience that I had. below id the simple raw data that we will be using against the Line Chart.

MonthSales
Jan100
Feb
Mar250
Apr50
May75
Jun375
Jul
Aug66

So we can see that we have null values for the Sales in the month of Feb and Jul. Now we will create a simple line chart against the Raw data and you can spot that on below chart we have a break in the line in the month of Feb and Jul which is not what we want.


So I created another measure using sales and added up 0 to it so as to handle the null value.

[Test]=[Sales]+0

The below chart is created with the newly created measure and you can see that now we are getting the chart way we want it.


Hope I was able to explain to some extent. feedback and suggestions are always welcome.

Regards

Niraj

10 Comments
Labels in this area