I'm trying to build a Profit and Loss for my company that is scalable. I've used the "Cascading Subtotals" post from the PowerPivotPro forum here: ( Profit & Loss–The Art of the Cascading Subtotal - PowerPivotPro)
The problem I'm running into is with my slicers and the ability to cross filter. We have multiple Divisions, which have multiple Regions, each with multiple Business Units.
I would like the ability to select a Division, Region or Business Unit and the other 2 Slicers cross filtered. For some reason, this isn't happening. I've ensured that the cross filtering is enabled via slicer settings.
My relationships are:
FactTable[BusinessUnits] > dimAssignments[BusinessUnits]
dimAssignments[Divisions] > dimDivisions[Division] *
dimAssignments[Regions] > dimRegions[Regions]*
*field is selected for Slicer.
The other slicer is dimAssignemnts[BusinessUnitText].
The problem I'm running into is with my slicers and the ability to cross filter. We have multiple Divisions, which have multiple Regions, each with multiple Business Units.
I would like the ability to select a Division, Region or Business Unit and the other 2 Slicers cross filtered. For some reason, this isn't happening. I've ensured that the cross filtering is enabled via slicer settings.
My relationships are:
FactTable[BusinessUnits] > dimAssignments[BusinessUnits]
dimAssignments[Divisions] > dimDivisions[Division] *
dimAssignments[Regions] > dimRegions[Regions]*
*field is selected for Slicer.
The other slicer is dimAssignemnts[BusinessUnitText].