The first step is to create a column of selections for the user to choose from. Note that his table would have no relation to the actual data set. It is there only to capture the user’s preference as an input. 

1. Add in a data table named as Measure Selection to contain the measure names which use for column selection:

You will see above I input a Order column, so that I can control the order of the measures to be shown in the slicer.

  • Once the table loaded in the data model, clicked on the Measure column and go to Column tools ribbon, select the Sort By Column: Order.



Then we create a dynamic measure which will change based on what is selected from the Disconnected table.



After that we can create a slicer for the Measure fields:


Then at the Matrix visual we would select the Measure name in the Columns field, and Values would be the Display Value which would show the calculation value from the measurement.