Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Bookmark action from map visual

Hi all,   I  need to toggle a matrix / table visual on and off , when user clicks a circle on the map visual. I ve created 2 bookmarks , one with a visible table including detail information of th...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    You can create a measure and a text box to achieve this instead of using bookmarks.

    Create a measure like this, put it in the table visual filter and set its value as 1:

    visual control =
IF (
    CALCULATE ( COUNT ( 'Table'[City] ), ALLSELECTED ( 'Table' ) )
        < CALCULATE ( COUNT ( 'Table'[City] ), ALL ( 'Table' ) ),
    0,
    1
)

    Create a text box without any values in it to hide the column headers of the table visual. When you click circles in the map, the visual would look like 'disappear'.

    Attached a sample file in the below, hopes it could help.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

You can create a measure and a text box to achieve this instead of using bookmarks.

Create a measure like this, put it in the table visual filter and set its value as 1:

visual control =
IF (
    CALCULATE ( COUNT ( 'Table'[City] ), ALLSELECTED ( 'Table' ) )
        < CALCULATE ( COUNT ( 'Table'[City] ), ALL ( 'Table' ) ),
    0,
    1
)

Create a text box without any values in it to hide the column headers of the table visual. When you click circles in the map, the visual would look like 'disappear'.

Attached a sample file in the below, hopes it could help.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That works... Such a nice idea..

     

    thanks a lot...

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Just one more question,

    what ever I do to format the visual (forward / backward) etc

    if I make the map wider so the visual overlaps it,
    it always stays visible in the back of the map
    I cant bring it to front and have the toggle effect.

     

    any ideas ?