Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Sorry for the basic picture, I am trying to display a running total graphically, the darker blue represents Actual amounts, and the light Blue represents Projections. They should always follow each other as the projection changes based upon the actual amount. I would like for the Actual Line to stop when it no longer is following the Projection. I have found a work around by using a variable date, however different reporting schedules has caused this to become a less then ideal fix. Please let me know if there is a simple way to get the darker blue line to stop, based on when it deviates from the light blue.
Try using an if statement
IF(SELECTEDVALUE([date_column]) > [date_to_stop_graph], CALCULATE())
Replace the 'CALCULATE()' statement with your running total calculation.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 34 | |
| 21 | |
| 17 |
| User | Count |
|---|---|
| 65 | |
| 63 | |
| 31 | |
| 26 | |
| 25 |