Dynamic Measure Display Based on User Selection in Matrix

[pawlowski6132]

Hi, quick question, I have a solution that allows my report users to add/remove the display of measure data in a Matrix visual. However, as you can see, the solution is not ideal. 

Is there a way to add/remove the measure itself and not just the data?

Thanx in advance.

[v-robertq-msft · Accepted solution]

Hi, @pawlowski6132 

After the test, I can just use measures to achieve the dynamic display of measures' data based on the Slicer selection, the title can’t disappear because the measures are placed into the value of the Matrix and they won’t disappear until you delete them from the Matrix manually, here are my steps:

I created the measures for the measures I want to slicer by the selection of Slicer:

Measure11 =

var _selectedmeasure=

SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])

return

IF("Measure1" in _selectedmeasure,[Measure1],BLANK())

Measure22 =

var _selectedmeasure=

SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])

return

IF("Measure2" in _selectedmeasure,[Measure2],BLANK())

Measure33 =

var _selectedmeasure=

SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])

return

IF("Measure3" in _selectedmeasure,[Measure3],BLANK())

And I created a Matrix and a Slicer table and place like this:

You can download my test pbix file here

Here are some possible ways to achieve adding/Removing matrix columns based on Slicer, you can check if they can meet your requirement in your situation:

https://community.powerbi.com/t5/Desktop/Adding-Removing-matrix-columns-based-on-Slicer-Filter/td-p/...

https://community.powerbi.com/t5/Desktop/Dynamic-Measure-Display-Based-on-User-Selection-in-Matrix/t...

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please look into the functionality of Calculation Groups and SELECTEDMEASURE()

[pawlowski6132]

thanx, will do