Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi there,
I am trying to create a Cumulative graph, I managed to pull up data and calculate values,
I am now struggling with removing values which are yet to be calculated for eg. Aug 19 and Sep 19.
I want to remove the line from the graph but would like to keep them on the axis
Thank you, 🙂
Let the measure return BLANK () and take advantage of Show items with no data.
Hi,
Assuming the blank line represents measure1, try this measure
=IF(ISBLNK([Measure1]),BLANK(),[Measure1])
Hope this helps.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 23 | |
| 23 | |
| 23 | |
| 14 |
| User | Count |
|---|---|
| 48 | |
| 33 | |
| 20 | |
| 18 | |
| 16 |