Forum Discussion
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 |
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.
5 Replies
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
Did you try to create custom IDs (key) to connect these tables and try it again ?
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.
