How can I put many columns to a slicer but not in hierarchy

[Verity]

Hello,

first of all, I apologise for my poor English.

I have many columns named "Number", each containing many numbers... I need to put them in a slicer or somenthing similar, to enable simple choice and switching of the column that should be visible in the visualisation.

I tried to merge the columns but this put only their values in the slicer, not the whole columns.

I work in Direct Query mode, so not all the functions are available.

Can you help me please?

Picture to illustrate what it looks like...

[Idrissshatila]

Hello @Verity ,

You could use field parameters to combine more than one column in a slicer.

check this link for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin