Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Running Total Stop on Today

Hi

 

I need your HELP.

 

I have a graph having 5 running total lines.

got runnitng total value by quick measuer. looking like this.

 

I want to stop the lines till today..!

 

Thanks,

  • Hi Anonymous ,

     

    You can create an extra measure, add it to visual level filter and set its value to 1.

    check = IF(SELECTEDVALUE('calendar'[Date])<=TODAY(),1,0)

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous ,

     

    You can create an extra measure, add it to visual level filter and set its value to 1.

    check = IF(SELECTEDVALUE('calendar'[Date])<=TODAY(),1,0)

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks so much!