Power BI Data Access, Transformation and Cleansing

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Filter slicer using inactive relationship

  • 1.  Filter slicer using inactive relationship

    Posted Mar 13, 2019 11:36 PM

    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
    ------------------------------