Forum Discussion
cummulative value without affected by slicer
Hello There I need some help with my report. i have two tables in excel which is as my source of my BI report. one contain dates, monthly achievement, running cummulative monthly achievement, mon...
wdx223_Daniel
Community Champion
Community Championi think it is hard to resolve this, if the x-axis value and the slicer value both come from date table.
if not, can try to remove the filters of slicers in the line measure.
=CALCULATE([Target Value],REMOVEFILTER(Slicers[Month]))
thanks, after two months the result is i have to build separate tables and it worked