How can I change the value in a matrix to change according to the filter selected

[RashmitaR]

HI , In my model I have the following columns: *Country *Products *cost price *selling price following measures: *profit *profit% In my report I have a matrix with rows as Country and Products and values as Profit and Profit%. But I want to create a slicer where in my client can choose where he wants to have a look at Profit or Profit% and accordingly in the matrix only profit or profit% or both will be visible . (Kindly note: Profit and Profit % cannot be changed to columns as in the actual model they are measures which is used to display a number of other measures from a different table)

[v-ljerr-msft · Accepted solution]

Hi @RashmitaR,

According to your description above, you should be able to follow steps below to get your expected result.

1. Add a new table with a single column of measure type to your model like below.

Type

profit

profit%

2. Create a new measure to show "profit" and "profit%" according to measure type.

Measure =
SWITCH (
    FIRSTNONBLANK ( NewType[Type], 1 ),
    "profit", [profit],
    "profit%", [profit%],
    BLANK ()
)

3. Add a Matrix to report with Rows as Country and Products and Values as the new created measure, Columns as measure Type from the new created table.

Regards