powerbi - Dynamic Measures in a Matrix - Stack Overflow

Afternoon all, am having trouble with matrixes and a multitude of measures.

Data Structure

• Sales Table
• Calendar Table (incl. Calendar year and fiscal year that runs from 01/10/20xx to 30/09/20xx

Currently I have a matrix set-up that is populated as follows:

Rows: BikeType (either E or T)

Columns: Fiscal Week, Fiscal Month, Fiscal Year, drilled to one of the three levels

Values: Using Measures:

• Actual Units Sold
• Forecast/BudgetTarget to sell
• Delta between Actual and Budget as %
• Previous Fiscal time period units sold
• Delta between Actual and Previous Fiscal time period
• Only previous Fiscal Year, running delta from start of current fiscal year vs previous fiscal year

Now. Units sold is not the only value that interests me. Also the value of these units needs to be displayed. I am reluctant to pack these into the existing matrix or create a new matrix for value, as the dashboard becomes quickly full.

Can I make all of the above referenced measures responsive to a slicer that I can use to switch between sum of units sold, and sum value of units sold?

Field Parameters looked promising, but I think I can only apply this to one measure at a time, and I want one Slicer to control 7 Measures.