Forum Discussion

Moulick's avatar
Moulick
Frequent Visitor
9 years ago

Thanks for replay Bhavesh Patel,

Here is my senario. which will know what i want.

Sample records
Table 1
vegetable
Fruits
Total

Table 2
brinjal
cabbage
potato
apple
mango
banana

- 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.
and
on 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)

 

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.

 

Thank you 

Moulick Patel

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Moulick,

In your scenario, firstly, please create another link table as follows.


Secondly,  create relationship between the link table and Table 2.


Thirdly,  create slicers using relevant columns. For more details, please review the example in this attached PBIX file.



Thanks,
Lydia Zhang

  • Moulick's avatar
    Moulick
    Frequent Visitor
    9 years ago

    Thank you Lydia Zhang,

     

    As per your poc.  new link table i have created,

    And what if i want to keep the all option in the first slicer selection too. 

    If i want both to selected at once as vegetable and fruits using all option in it.

     

    Thnak You 

    Moulick Patel.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Moulick,

      Just press Ctrl on your keyboard, then click the other option in the first slicer.



      Thanks,
      Lydia Zhang

  • Deepa's avatar
    Deepa
    Frequent Visitor
    8 years ago

    It works only if you are using 2 slicers in a report, It doesn't work if you display some other data along with this in another visuals. 

  • NhiLe297's avatar
    NhiLe297
    Frequent Visitor
    5 years ago

    Anonymous Hi Lydia,

     

    I have a question about this what if besides fruit and vegetable you have other things as well.

    For example:

    Fish but this one does not expand into any drop-down check box and will be on the same level with fruits and vegetables?