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!!
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!!