Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Show/Hide visuals

I have a bubble map in my report which has a bubble for specific latitude/longitude.  Underneath the map I have some visuals that I would like to have hidden until a single bubble is selected. 

 

I have a text box that overlays the visuals that I want to show/hide which I am controlling the color of with a measure.  So it is gray if no bubbles are selected and then turns transparent once a bubble is selected.

 

ShowHideDeviceDetails = 
var devicecount = CALCULATE(DISTINCTCOUNT('Table'[TableKey]),ALLSELECTED())
return IF(devicecount = 1,"#FFFFFF00","#F4F4F4")

 

The functionality of the measure controls the color of the text box just fine.  However, since there is a text box on top of my visuals I cannot interact with those visuals.  One of them is a table, and I am unable to scroll inside of my table.
 
Is there a better way to show/hide visuals so that I can interact with the visuals when they are not hidden?  Here is a screenshot of the visuals when they are shown. 
 
Need Help
Tips and Tricks

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Anonymous  - I hope the below thread helps,

     

    Solved: Hide and Show visuals based on condition - Microsoft Fabric Community

     

    check it.

     

    i tried with below measure that detects whether a single bubble is selected or not. You already have a measure similar to this to control bookmark navigation

     

    IsSingleSelection =
    IF(
    CALCULATE(DISTINCTCOUNT('Table'[TableKey]), ALLSELECTED()) = 1,
    "Selection",
    "No Selection"
    )

     

    for visibility  and apply the same on conditional formatting.

    ShowVisuals =
    IF(CALCULATE(DISTINCTCOUNT('Table'[TableKey]), ALLSELECTED()) = 1, 1, 0)

     

    Try the above approach too

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    rajendraongole1 amitchandak  Can you help me understand how I could use a bookmark in this case?  How can I change the status of a bookmark based on a measure?