Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
Tips and Tricks
Tutorial Requests
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

SpiroswayGR's avatar
SpiroswayGR
Resolver III
5 years ago

Anonymous 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • SpiroswayGR's avatar
    SpiroswayGR
    Resolver III
    5 years ago

    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.