Power BI Data Access, Transformation and Cleansing

Filter slicer using inactive relationship

  • 1.  Filter slicer using inactive relationship

    Posted 4 days ago

    Hi guys,

    How to make my slicer correspont with another slicer which has inactive relationship between them.

     I have one slicer, lets say Company, which already put as slicer :

    Company
    DEMF
    BGR
    SME

     

    And then I have Worker Table like below:

    Worker Company
    Julie BGR
    Garry BGR
    Lisa DEMF
    Matt SME
    Sophie SME

     

    I cannot put active the Relationship because it already connect with some other table, so im my Worker slicer now, it display all of them instead what already selected in Company slicer



    ------------------------------
    Morgan Fields
    Hunter Douglas
    172493578
    ------------------------------