The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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
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?
So do you have logic for that? if not, is it randomly?
How do you update the logic or mapping normally? using excel?
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?
Hi @kmkwongaa
It's not accessible currently.