Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a time series chart with a year to date cumulative/running total. How do I level off the line at a certain peak number once it has been reached?
@JediCB , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Assume you created YTD with help from date table
//measures like
YTD= TOTALYTD(SUM(Table[Value]), Date[Date])
Peak Month = Maxx(Values(Date[Month Year Sort]), [YTD] ) //Assume there are negative otherwise, last month will be max
Cut at Max
New Measure = if(Max(Date[Month Year Sort]) > [Peak Month], blank(), [YTD])
Appreciate your Kudos.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |