Forum Discussion
Line Chart showing Prior dates
Hi Anonymous
insert your DAX calculation (for Observations Tot Incidents) in this IF statement.
[Observations Tot Incidents] =
IF ( ISBLANK ( [Tot_#_Incidents] ), BLANK (), <DAX for Observations Tot Incidents> )If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi mwegener ,
Made the changes, but still no changes in the Line Chart as it still is showing information to Jan 2018. My data only goes back to June 2018!
Hi Anonymous ,
could you give an overview of your model and the values on your line chart?
I'm trying to create a Line Chart which showcases the average of the Total No. of Incidents across the available months of data as a straight line.
I currently have a column called [Tot_#_Incidents] with Values for each Month up until June 2019.
When I try to calculate the number of observations and average, I can see that it extrapolates to include months which I have no data. However, the number of observed month is correct as 19 is the no. of months from June 2018 - December 2019.
Is there any way I can filter out the Measure used to only include those months where No. of Incidents > 0 ?