Forum Discussion
Help - dependent filters with same items
Hi All,
I have a master table like below,
Customer_ID | Channel_1 | Channel_2 | Channel_3 | Channel_4 |
1 | Y | N | Y | N |
2 | N | Y | N | Y |
3 | N | N | Y | Y |
4 | Y | Y | N | N |
5 | Y | Y | Y | Y |
6 | N | Y | N | N |
7 | Y | N | Y | Y |
8 | N | Y | Y | N |
9 | Y | N | N | Y |
10 | Y | N | Y | N |
What I need is a view where a user can prioritize channels using four slicers as given below,
For illustration purpose I have created 4 tables with same data and used Slicer filters to restrict list items, but I want it to be dynamic like once the user selects a channel in "Priority 1" then that channel should not be there in the subsequent slicers and so on. How to achieve it?
Also, once the user completes all selections; it needs to link back to master table in such a way that in a table view it should show the "Customer_ID"s after filtering the data in the same order as user selection. For example, if user selects Priority 1 is "Channel 4" then it should apply filter as Channel_4=Y in the master table and Priority 2 is "Channel 3" then Channel_2=Y in the master table and so on. Result will be Customer_ID=5 in this case.
How to do this?
Any help on this is much appreciated. Thanks in Advance!
Hi BijoyAK ,
Based on my test, it is unsupported to achieve your requirement if create four slicers. Using the Unpivot feature and then create single slicer is a kind of alternative method, and you may have a try.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
BijoyAK , you need to unpivot data.
https://radacad.com/pivot-and-unpivot-with-power-bi
What is objective of channel priority
Thanks for the reply Amit !
The final objective of this is population a table like this,
Mutually Exclusive Customer Counts (Based on Channel Priority) Channel_4 5 Channel_3 3 Channel_2 1 Channel_1 1 I hope this clarifies your query.
Hi Amit,
By unpivoting we can have all channells in a single column and it will be easy to make a slicer with all channels in it. I understand this part. But creating 4 slicers with same items and eliminating items from subsequent slicers according to the selections made is the part I am not clear about. Please correct me if my understanding is wrong.
Hi BijoyAK ,
Based on my test, it is unsupported to achieve your requirement if create four slicers. Using the Unpivot feature and then create single slicer is a kind of alternative method, and you may have a try.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi BijoyAK ,
You may enter into Query Editor, select on the columns [Customer_ID], right click to choose option "Unpivot Other Columns" . Then you may rename the result column Attribute with "Channel", don’t forget to click button "Close & Apply".
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
