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.
Month | Sales |
---|---|
Jan | 100 |
Feb | |
Mar | 250 |
Apr | 50 |
May | 75 |
Jun | 375 |
Jul | |
Aug | 66 |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |