Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line Chart showing Prior dates

Hi, I'm trying to create a Line Chart to show the Average and also the UCL and LCL.   To calculate this, I have the following metric: [No. of Incidents] [Incident_Month_Year] I also have some a...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

Hi mwegener ,

 

Yes - aware of the Visual Filter, but would rather make the modications on the Measures.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

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.