Forum Discussion
Helper VMultiple columns in slicers without hierarchy
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
3 Replies
- Idrissshatila
Super User
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 👍
BIanonThank 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.
sudhavtry this, but you have to update your power bi desktop to get this feature
