Creating a Bar Chart for running total.

[mesuyog]

Hi i have created a running total with following DAX

1_Running total All Select = CALCULATE ( SUM('US Superstore data'[Sales]), FILTER ( ALLSELECTED ( 'Date'[Date] ), 'Date'[Date]<= MAX ( 'Date'[Date])))

but when i take this measure into bar chart for yearly it shows good...but when i drill down it gets missplaced...

[mesuyog]

@amitchandak  Thank you...it solved my issue...

[amitchandak · Accepted solution]

@mesuyog , date in visual should come from date table and Date table should be marked as date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...