Forum Discussion
Line Chart Visual omits days (x-axis point) without data - Seeking work around
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.
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
