Forum Discussion

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

Line & Bar Chart

Hi, I want to stop the future Cumulative line values from appearing from the line below, I only have Apr so I dont want to see future months.   The code for the line is: DD YTD Cases = CAL...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Assuming the Month names on the X-axis have been dragged from the Date2 table, write this measure

    Measure = if(min('Date2'[Date])>today(),blank(),[DD YTD cases])

    Hope this helps.

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

Thanks! this works which is great ğŸ˜Š

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

You are welcome.