Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

One or two bookmark per table?

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
1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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:

v-henryk-mstf_0-1611797411851.png

Put the created measure in the filter:

v-henryk-mstf_1-1611797422311.png

v-henryk-mstf_2-1611797430025.png


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

v-henryk-mstf_3-1611797443648.jpeg

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.

View solution in original post

5 REPLIES 5
v-henryk-mstf
Community Support
Community Support

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:

v-henryk-mstf_0-1611797411851.png

Put the created measure in the filter:

v-henryk-mstf_1-1611797422311.png

v-henryk-mstf_2-1611797430025.png


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

v-henryk-mstf_3-1611797443648.jpeg

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
Not applicable

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

SpiroswayGR
Resolver III
Resolver III

@Anonymous 

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

Anonymous
Not applicable

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

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.