Forum Discussion

ArchStanton1's avatar
ArchStanton1
New Member
2 years ago
Solved

Blank out Future Values in Chart

Hi,   Is there a way I can stop the black line at September so it only populates months that are current or in the past?   DD YTD Cases = CALCULATE( TOTALYTD(COUNT('Cases'[Case Number]),'...
Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi  ArchStanton1 , there are several ways to filter out months without data for example :
    Submitted_cases = calculate([DD YTD Cases], FILTER(ALL(Date),Date[Date]<=max(Date[Date])))

    For a more detailed solution please share a dummy file to work with.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi  ArchStanton1 , there are several ways to filter out months without data for example :
Submitted_cases = calculate([DD YTD Cases], FILTER(ALL(Date),Date[Date]<=max(Date[Date])))

For a more detailed solution please share a dummy file to work with.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

 

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    2 years ago

    Hi Rita, Apologies for the delayed acknowledgment, i thought I had already responded & approved this.
    Your solution works perfectly!

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      2 years ago

      Happy to help 🙂