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.
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 ?
Hi Anonymous ,
i think so. Could you post your measure definition?
Can't you put a visual filter (line chart) on the measure [Tot_#_Incidents]?
Hi mwegener ,
Yes - aware of the Visual Filter, but would rather make the modications on the Measures.
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.
Anonymous
You may take a look at the post below and try ISEMPTY if necessary.
https://community.powerbi.com/t5/Desktop/Forecasts-for-year-and-actuals-for-ytd-only/td-p/825702
