Does PowerBI have some matching feature with the filter function?

[kmkwongaa]

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?

[Anonymous]

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]

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]

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

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

[kmkwongaa]

User can match the result based on their decision, as long as the amount of loan do not exist the amount of project.

Is it can be done in powerbi?

[v-diye-msft]

Hi @kmkwongaa 

It's not accessible currently.