Is there any way I can do matching by check box on the dashboard page?

[kmkwongaa]

I would like to do matching on the dashboard page. Is there any way I could save the relationship of Project A to Loan1 and 2.

And after I click on Project B, I can match it with other Loan3 and 4.

After that, I hope the system could remember what did I matched for Project A and once I click on Project A, Loan 1 and Loan 2 can be selected.

May I ask is there any way to achieve this saving the matching result feature in PowerBI?

[Mariusz]

Hi @kmkwongaa 

You can create 2 x project dimension tables, then slicers and Measures for each, this way you have 2 selections that you can compare against each other.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[kmkwongaa]

@edhans  Thanks a lot. This is a great one. I will try it. 

@Mariusz Could you please elaberate more? Do you mean one for project and one for loan or you really mean two project dimension table? I am a little bit confused.

[edhans · Accepted solution]

You can use the bookmarks feature, then use Buttons to switch between them. See this article for details.