Filter slicer based on the another slicer

Question

I want to know that there is any way using which i can filter the slicer records based onthe another slicer value selection.&nbsp;Eg. I want to keep the selection of vegetable,fruitsand on the basis of the selection of the vegetable or fruits the next slicer shouldfilter the records in the next filter like vegetable -&gt; potato,cabbage,brinjaland Fruit -&gt; apple,mango,banana.

anonymous · Answer

Hi&nbsp;Moulick,  In your scenario, firstly, please create another link table as follows.  Secondly, &nbsp;create relationship between the link table and Table 2.  Thirdly, &nbsp;create slicers using relevant columns. For more details, please review the example in this attached PBIX file.    Thanks, Lydia Zhang

bhaveshpatel · Answer

Yes. You can do that.&nbsp;You need to create two slicers for the requirement. For example, one for the Vegetables and Fruits &amp; one for their names.&nbsp;Just to clarify, it does not automatically recognize the names of the vegetables and fruits &amp; you need to predefine them in your columns.&nbsp;&nbsp;Filter on one slicer will automatically cross filter other slicer and that's the native behaviour of PowerBI.Hope this has clarified your understanding.&nbsp;&nbsp;Thanks &amp; Regards,Bhavesh

moulick · Answer

Thanks for replay Bhavin Patel,&nbsp;&nbsp;The solution you provided it can't be used, as there is no relation between the tables, because it contains the duplicate values in the column.&nbsp;&nbsp;Thank you&nbsp;Patel Moulick&nbsp;&nbsp;&nbsp;

bhaveshpatel · Answer

Hi Moulick,&nbsp;Can you please post the sample data and expected output to provide you the exact solution.&nbsp;Thanks &amp; Regards,Bhavesh

moulick · Answer

Thanks for replay Bhavesh Patel,Here is my senario. which will know what i want.Sample recordsTable 1vegetableFruitsTotalTable 2brinjalcabbagepotatoapplemangobanana- Here i want to keep the table1 in the slicer and on the select of vegetable or fruits.- The record should be filter in the 2nd slicer.Eg. IF vegetable selected then brinjal,cabbage,potato.IF fruits selected then apple,mango,banana.Note(There is no relation beteween this two tables , and cant create any relation)Output:-On selection of vegetable in the slicer 1 then the slicer 2 should filter with brinjal,cabbage,potato.andon selection of fruits in the slicer 1 then the slicer 2 should filter with apple,mango,banana.(Logically as on the bases of the one slicer i have to filter the records in the slicer 2)&nbsp;or there is any way that i can apply column level filter to the slicer, so when i select vegetable it filters and shows records as per the filter.&nbsp;Thank you&nbsp;Moulick Patel

Forum Discussion

Filter slicer based on the another slicer

10 Replies

Related content

Slicer Filtering Another slicer

Filter Slicer values based on another slicer

Slicer filter another slicer

Clear One Slicer when Filtering on Another Slicer

Time Filter Slicer