Power bi - power bi designer -

[neobaron]

Hello all,

I am creating a Dashboard. Dashboard is feding from 3 Excel Shets. Those excel sheets have same variables and only amounts changes. I am doing all dashboard againts the last sheet (more recent) but i would like to introduce an overview of how the amount changed.

CALCULATE(SUMX('Main Data','Main Data'[Savings]),ALLEXCEPT('Main Data', 'Main Data'[Region],'Main Data'[C/O],'Main Data'[User)])))

My problem is:

That formula doens´t work with Slicers.

I can´t see the evolution of three sheets in one chart because is summarizing all, so all is in one chart bar.

Any idea? Any formula?


Thank you!!

 

[neobaron]

Fixed!! i filtered the amount with one LastDate... too simple