Forum Discussion

kmkwongaa's avatar
kmkwongaa
Icon for Helper I rankHelper I
6 years ago

Does PowerBI have some matching feature with the filter function?

Let say I have 3 projects : Project A , Project B, Project C

and I have 5 loans: Loan1, Loan2, Loan3, Loan4, Loan5

 

I would like to match the Loan to Project and save it for result matching and visualization.

Which mean every time I click on check ProjectA, Loan1 and Loan2 will be checked, and when I click on Project B, Loan 1 and Loan 2 will be unchecked. 

 

Is there any way to do this kind of matching and save it status?

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi kmkwongaa ,

     

    I think you're talking about a mapping table.

     

    You can create a mapping table in the back-end to make it.

     

    Aiolos Zhao

    • kmkwongaa's avatar
      kmkwongaa
      Icon for Helper I rankHelper I
      6 years ago

      But how if my mapping is dynamic, which mean Project A could be mapped with Loan 1, Loan2 , it can also be mapped with Loan3, Loan4 , Loan5 and other combination?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        So do you have logic for that? if not, is it randomly?

         

        How do you update the logic or mapping normally? using excel?