Forum Discussion
Solved
Creating a Bar Chart for running total.
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 , 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-bd52912a5bd4
2 Replies
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-bd52912a5bd4amitchandak Thank you...it solved my issue...
