Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Running total to show full timeframe (Where there is no data points as well)

I have calculated running total using this formula : 

CALCULATE(
    COUNTA('DIM - Analysis'[_id]),
    FILTER(
        ALLSELECTED('DIM - Analysis'[date]),
        ISONORAFTER('DIM - Analysis'[date], MAX('DIM - Analysis'[date]), DESC)
    )
)
 
but when I am selecting a perticular month on slicer the graph ends at last data points, does not at the end of the selected interval  but I want to show a straight line which will begin from last data points till end of selected interval ends.
02.JPG
here I have selected the month "November". The last data points on the graph I marked was at Nov 24 and graph ends there , I want it to show a straight line till end of Nov.  I have tried but couldn't succeded, It would be great if someone help me pull this off.  Thanks in Advance for helping me 🙂
1 REPLY 1
lbendlin
Super User
Super User

What's the business value of showing a straight line for December?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.