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.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 47 | |
| 35 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 59 | |
| 57 | |
| 40 | |
| 22 | |
| 20 |