One or two bookmark per table?

[Anonymous]

Hello Guys!

I would really need some help. Okay so, I have an Area table, when I click on the item Europe I would like the Status table to appear automatically, if I uncliked it the Status table will disappear. If I chose the item Asia I want the URL table to appear. I've done it in Bookmark but it only allows one Bookmark per table so if I click any item from Area table it shows the same table every item. Do you guys have any suggestions or any alternate feature I can use on this one?

I have also consider using tooltip but I guess you cannot insert another table inside and click on it?

Area

Europe

Asia

Status

Q1 2021

Q2 2021

URL

https://1

https://2

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your needs, I did the following test: Create a measure to be used as a filter, and set the filters of the Status and URL tables respectively. Reference is as follows:

Put the created measure in the filter:

When selecting Asia in the Area table, the Status table is displayed correctly:

Here is the sample pbix file for reference.

If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I already lose hope on this. This is awesome! Thank you so much Henry!

[SpiroswayGR]

@Anonymous 

Did you try to create custom IDs (key) to connect these tables and try it again ?

[Anonymous]

No, how should I do that? create custom IDs on Area table?

[SpiroswayGR]

just add extra column with ids : 1 , 2 , 3 , 4 or more advanced if you want something more complex.

If you table is excel will be easy (or table in SQL) and then import in Powerbi.