Forum Discussion
Line Chart Visual omits days (x-axis point) without data - Seeking work around
Hi, seeking a solution to a minor formatting issue. My data source has a the folowing fields: category, date and volume. However, not all dates are represented in the source data, so when a line chart is created, there's in not a pin point on the x-axis for the missing dates in th esource. Meaning , it will display days 1 2 3 5 6 7, a long the X-axis but omit day 4.
I have created a Calendar table using the funuction "Calendar = Calendarauto()" This a long with checking the option to "Show items with no data" on the field value. This force the missing day to appear, however the graph now has broken segments.
Does anyone havea good work around for this issue?
Thanks Terry
Hi tbobolz ,
Thanks for the reply from AnalyticPulse , please allow me to provide another insight:
Based on your description, I created these data.
1. created date table and created relationship between two tables.2. created measure.
Measure = VAR _date = DISTINCT('Table 2'[Date]) RETURN IF(MAX('Table'[date]) IN _date,MAX('Table'[value]),0)3. Put appropriate fields for the visual object.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi tbobolz ,
Thanks for the reply from AnalyticPulse , please allow me to provide another insight:
Based on your description, I created these data.
1. created date table and created relationship between two tables.2. created measure.
Measure = VAR _date = DISTINCT('Table 2'[Date]) RETURN IF(MAX('Table'[date]) IN _date,MAX('Table'[value]),0)3. Put appropriate fields for the visual object.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Clara!!! This works great. Any way to keep the Zero plotted points from appearing for future date?
Hi Clara,
I just notice this formula only returns the MAX as your statement suggest.
IF(MAX('Table'[date]) IN _date,MAX('Table'[value]),0)My data table has multiple values on the same day, so the others are being ignored. I can't seem to figure out how to remove the "MAX" condition so that it reconize all values on the same day and adds them into the graph.
Thanks for helping me learn!
Terry
Terry
hello tbobolz haev you tried using diffrent chart? like create a new line chart and then put your feilds in the chart, the chart should normally show the dip and the suddent hike if you have data like that.
there is nothing wrong with your approach just try another chart.https://analyticpulse.blogspot.com
Thank you for th eresponse, I have tried several others with no success. I beleive it is because my data omits dates with no values.
Apprecaite the response!
Terry
