Forum Discussion
Custom slicer with multiple conditions
I have data table in this form:
A B
Val1 Top10
Val2 Top10
Val3 Top25
Val4 Top50
Val5 Other
How can I create custom slicer than will allow me to filter the table using B column (Top10, Top25, Top50, Other), but also when I select Top50 I also select Top25 and Top10 values, and when Top25 I select aslo Top10?
Hi atpbi10 ,
Please create a new table in Power Query Editor:
let Source = Table.SelectColumns(Table, "B"), #"Added Custom" = Table.AddColumn(Source, "SelectValue", each Table[B]), #"Expanded SelectValue" = Table.ExpandListColumn(#"Added Custom", "SelectValue"), #"Removed Duplicates" = Table.Distinct(#"Expanded SelectValue"), #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each ([SelectValue] <= [B] and ([B] = "Other" or [SelectValue] <> "Other"))) in #"Filtered Rows"Then create a relationship in 'Slicer'[SelectValue] and 'Table'[B].
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi atpbi10 ,
This video might help you:
https://www.youtube.com/watch?v=QtEt-QI3oe4
Please hit the thumbs up if it does. Thanks.No it doesnt sovle the problem. I already ranked the values according to my internal algorithm using Python. They have the labels in B column, I need a custom slicer/filter that can accept multiple conditions.
Someting like SWITCH but I dont know how to make it work.
Hi atpbi10 ,
Correct me if I am wrong, you want multi select in your slicer? if yes then you need to enable below property of slicer and if you want multiselect without pressing CTRL then you can enable show "select all" option
Thanks,
Samarth
No, I want to create a custom slicer/measure that allows me to create custom selection.
So in the slicer I would have the option "Top 25" that will select all values that have "Top 25" and "Top 10" in column B.It is not multi select I need a custom select.
Currently in slicer when I select Top25 only one row is shown in my example. it should show 3 rows (both top10 and top25)
Hi atpbi10 ,
Please create a new table in Power Query Editor:
let Source = Table.SelectColumns(Table, "B"), #"Added Custom" = Table.AddColumn(Source, "SelectValue", each Table[B]), #"Expanded SelectValue" = Table.ExpandListColumn(#"Added Custom", "SelectValue"), #"Removed Duplicates" = Table.Distinct(#"Expanded SelectValue"), #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each ([SelectValue] <= [B] and ([B] = "Other" or [SelectValue] <> "Other"))) in #"Filtered Rows"Then create a relationship in 'Slicer'[SelectValue] and 'Table'[B].
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
