How to add columns to a table based on selection by a slicer

[Jeremy19]

I'd like to be able to add numerical columns to a matrix depending on the selection of column names by a user using a slicer. I was thinking of using a field parameter but that doesn't seem to work. For exemple, I have the data :

id	Col1	Col2	Col3
A	100	90	50
B	80	95	60

Is it possible to have a slicer with a choice of numeric columns (Col1, Col2 or Col3) which can be used to display or not the value of these columns in a matrix with the ID in the row and the selected columns in the column ?

Thanks

[v-yangliu-msft]

Hi  @Jeremy19 ,

Here are the steps you can follow：

1. In power query – select [Col1], [Col2], [Col3] – Transform – Unpivot Columns.

2. Placing fields into the matrix.

3. Result:

Best Regards,

Liu Yang

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

[Jeremy19]

Thank you for this suggestion, which works well for the example. The problem I'm having, however, is that I have a lot of columns that are created in DAX and which therefore don't appear in Power Query. Is there a solution for doing this outside Power Query?