Dynamic Measure Display Based on User Selection in Matrix

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/254107

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

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.