How to use Parameter/Slicer to control the selection of differnet column

[e2liu77]

Hi,

I have a table with 3 different columns, like column  A = A type, column B = B type, column C = C type.

I would like to implement a slicer,  when choosing slicer value  = A Type, a new column D will show A type column value. When choosing slicer value = B Type, Column D will show B type column value, and so on.

Is it doable?

Thanks!

[vicky_]

Have you looked into using field parameters? https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[e2liu77]

Hi @vicky_ ,

I created a parameter with 3 options.

Parameter = {

    ("A Type", NAMEOF('Table'[A Type]), 0),

    ("B Type", NAMEOF('Table'[B Type]), 1),

    ("C Type", NAMEOF('Table'[C Type]), 2)

}

But how to connect Parameter to "Table"[Selected Type] as a column? When choosing parametr = A Type, I want column [Selected Type]" shows Column [A type]'s value.

Thanks.

[vicky_]

You use the parameter value as the value in your visuals. If you followed the steps in the link above, there should be a slicer on your dashboard that you can use to select parameter = A, B, C etc. and that's how you select which type is shown.