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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors