Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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.
| User | Count |
|---|---|
| 50 | |
| 39 | |
| 29 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 68 | |
| 57 | |
| 40 | |
| 22 | |
| 19 |