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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi guys,
I made the following cumulative graph:
And used the following measure:
Measure = IF(SELECTEDVALUE('DateTabel'[Date]) > CALCULATE( LASTDATE(Tonnage_table[Day]), ALL(Tonnage_table)), BLANK(),
CALCULATE( SUM(Tonnage_table[Tonnage]),
FILTER(ALLSELECTED('DateTabel'),
'DateTabel'[Date] <= MAX('DateTabel'[Date]))))
Now i would like to show zero when there is no data and start over with the cumilative graph like i show below in red line.
The results should look like this :
@Anonymous ,
Create measure +0 if needed
Measure 10 = IF(SELECTEDVALUE('DateTabel'[Date]) > CALCULATE( LASTDATE(Tonnage_table[Day]), ALL(Tonnage_table)), BLANK(),
CALCULATE( SUM(Tonnage_table[Tonnage]),
FILTER(ALLSELECTED('DateTabel'),
'DateTabel'[Date] <= MAX('DateTabel'[Date]))))+0
Change type to categorial
What is +0 supposed to do ?
When I changed to categorical and use inteval year then its not is the graph not readable anymore, on top of that it dosent give me the desired result.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.