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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

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]?

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.