Forum Discussion

smjzahid's avatar
smjzahid
Icon for Helper V rankHelper V
5 years ago
Solved

How to customise Line Chart Visual to stop at certain date

I have a Line Chart which connects to excel and has a Running Total calculated as shown below         Value running total in Attribute = CALCULATE( SUM('BFO Summary (Weekly)'[Value]), ...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, smjzahid ;

    You could create a measure  and apply it into chart filter, as follows:

    flag = IF(MAX([Date])>DATE(2021,7,11)&&MAX([ Baseline/Actual])="Actual",0,1)

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, smjzahid ;

You could create a measure  and apply it into chart filter, as follows:

flag = IF(MAX([Date])>DATE(2021,7,11)&&MAX([ Baseline/Actual])="Actual",0,1)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.