Forum Discussion
Grouping Slicer Options
Hi,
I want to leave the Category Data in the chart to the user's selection. However, I will present the data to the user in groups, not one by one. My problem is that some data is in more than one group.
Table:
Objective:
The user will see one slicer input. The options will be positions like "CB", "RB", "LB" etc. If he clicks on "CB", certain "label" categories will appear on the chart. To help you, I created a column called "Group". For example, the metric "Aerial Duels" will be in both CB, DM and CF options. In other words, the metric will appear in all three options.
How should we proceed?
What have I tried and it didn't work?
I created a second table as above. It had a many-to-many relationship with the main table. I added the "Position" column from this new table to Slicer. However, the problem with this method was that the metrics other than the metrics belonging to the selected Position did not disappear in the chart, but they were fixed to the top value.
Help me!
Hi, sezerunar
You can try the following methods. Create a new slicer table as shown here.
Table:
Slicer table:
Measure = IF(SEARCH(SELECTEDVALUE('Slicer table'[Slicer]),SELECTEDVALUE('Table'[Group]),1,0)<>0,1,0)Place measure in the view to be filtered and set it equal to 1.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, sezerunar
You can try the following methods. Create a new slicer table as shown here.
Table:
Slicer table:
Measure = IF(SEARCH(SELECTEDVALUE('Slicer table'[Slicer]),SELECTEDVALUE('Table'[Group]),1,0)<>0,1,0)Place measure in the view to be filtered and set it equal to 1.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.