In Matrix when I select a value in slicer that value should show in the matrix rest should be hided

[Anonymous]

Hi Guys,

            When i select a value in the slicer the matrix should show that value only rest should be hided.

in this below image i have selected clicks clicks values are showing in the matrix and the other values impressions, sales and spend are showing blanks but my requirement is to hide these columns. Please help me on this thanks in advance.

[Icey · Accepted solution]

Hi @Anonymous ,

How about show values of "Clicks", "Sales", "Spend", "Impressions" in one measure? And then the result will be what you want.

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[MFelix]

Hi @Anonymous ,

What is the measure you are using for the metric picker?

For having a  setup like this you need to have a disconnected table with the measures names that you use for your columns on the matrix and then a measure similar to this one:

MeasureSelection =
SWITCH(
SELECTEDVALUE(MeasuresTable[MeasureName]),
       "Measure1", [Measure1],
       "Measure2", [Measure2]
       )

And use this measure has your values on the matrix.

[Anonymous]

@MFelix It won't work for my requirement.

Similar formula only i have used to create the metricpicker.

[MFelix]

And where are you getting the values for the slicer? Is it a disconnected table? Is it the same table?

Can you share how your model is setup?