Multiple columns in slicers without hierarchy

[BIanon]

Hello Community,

I have a table of users and I have some columns containing tags for these users created using some criterias. These tags are done on predetermined periods of time meanin a user has one tag per year.

I am looking to put these tags into a slicer, but cannot figure out how to do it when the data is not a hierarchy.

Tags are essentially structured like this:

UserId	Tag1	Tag2
1	High	Low
2	Medium	Medium
3	Medium	Low
4	High	High
5	Low	High

I would like the slicer to behave the same as if it had one of these but with both of them so I don't have to add multiple slicers

When you fold out the slicer it should just have two options:
* Tag1

* Tag2

[Idrissshatila]

Hello @BIanon ,

You could use field parameters, you add these two fields in a field parameter and you display the value of the parameter in the 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, Appreciate your Kudos 👍

Follow me on Linkedin

[BIanon]

Thank you for your reply.

This gets the structure I want but I am still unable to fold out the fields in the parameter. This way I can choose between the two tags but I cannot choose the actual tags inside of a column.

[sudhav]

try this, but you have to update your power bi desktop to get this feature