Add/Remove Columns of Matrix Visual Using Slicer

Hi oliverblane ,

For this you need to create a disconnected table with the following format:

Now add the following measure:

Selected Measure value = 
            SWITCH( SELECTEDVALUE(Matrix_Selection[Measure]),
            "Allocated" , SUM(Measure_Selection[Allocated]),
            "Attended", SUM(Measure_Selection[Attended]),
            "Planned Capacity", SUM(Measure_Selection[Planned Capacity])
              )

Add the Measure column from the previous table on the column below the Month, and the measure above on the values.

Result below and in attach PBIX file.

Has you can see the matrix on the bottom only show selected measures.