Forum Discussion

Szokens's avatar
Szokens
Icon for Helper II rankHelper II
1 year ago
Solved

Hiding/unhiding Objects/Values/Measures when nothing is selected

Hi Everyone, I have following use case. When I enter to my report I have to make a choice in STEP 2 - so select a Name. Once a Name is selected in slicer, then many elements are filled by data like...
  • Shahid12523's avatar
    1 year ago

    Create a measure

    ShowContent = IF(HASONEVALUE(act_source[Signature Team Name]), 1, 0)


    Apply it as a filter

    For tables/cards: Add ShowContent = 1 in the visual-level filter.

    For shapes/narratives (no filters): Use an overlay shape + bookmarks to hide until selection is made.

    That way, Sections B, C, D stay blank until a Team Name is selected.

  • v-ssriganesh's avatar
    1 year ago

    Hi Szokens,

    I have reproduced your case in Power BI Desktop and was able to achieve the expected behavior and I used the Overlay + Bookmark approach with Apply / Reset buttons:

    • Apply Selection button → hides the overlay and reveals Section C once a team is selected.
    • Reset Selection button → shows the overlay again, hiding Section C.

    This ensures the sections stay blank when no team is selected, and only display the correct data once a selection is made.

    For your reference, I am attaching a sample .pbix file that demonstrates this approach end-to-end. You can open it, explore the bookmarks and buttons, and adapt the solution to your report.

    Hope this helps you achieve your reporting requirements! Please let us know if you need any additional clarifications.

     

    Best regards,
    Ganesh Singamshetty.