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

[Szokens]

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 main table (section A), and other sections like B or C (and D at the bottom of C, not captured by my image).

Sections B, C and D are groups of elements like i) narratives, ii) tables, iii) shapes (below screenshot example).

What I try to achieve is to keep section C and D blank until user select Team Name in section A (when no selection of Team Name is made). For now it seems like these sections C and D pick data from first row in a sliced semantic model in STEP 2, when nothing is selected in section A (see this 1280 team name in section C). Once I make a selection in section A correct data appears in C and D. I have already tried few workarounds but they failed:

a) creating a measure like blank_or_not = int(HASONEVALUE(act_source[Signature Team Name])), then I would like to apply this measure with value = 1 as a filter visual for specific elements in groups. However looks like I am not able to do it at all for narratives nor shapes (no visual filter section available) and while for table this filter section is available, i cannot change it's settings (change from "is less than" to "is" for example).

b) similar measure filter I would like to apply to whole group, however no option available to apply visual filter like in a)

c) I was try then to create a standalone shape, which covers these sections while blank_or_not = 0 and dissapear when blank_or_not=1 however conditional formatting of shape doesn't allow me to make it transparent where value of my measure is 1

d) I have tried to apply blank_or_not measure filter to whole page, without any sucess - I couldn't drag and drop it there.

e) I found time consuming workaround which I would like to avoid. So for every data field like column, calculated column or calculated measure used in my visual to be hidden, I need to apply following condition: 

IF((HASONEVALUE('act_source'[sample_column)),VALUES('act_source'[sample_column]),"") 

However, as said this is time consuming and impacting my semantic model weight as for every field used in sections C and D (even original fields from semantic model) I had to manually create calculated column / adjust current measures or calculated columns.

Could anyone be able to help me to achieve my goal?

[Shahid12523 · Accepted solution]

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]

Hello @Szokens,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hello @Szokens,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh · Accepted solution]

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.

[v-ssriganesh]

Hi @Szokens,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Shahid12523 for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[Shahid12523 · Accepted solution]

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.

[Szokens]

hi @Shahid12523  thanks for ideas, I would be interested in overlay shape approach - could you please elaborate more how to setup this? I have a problem how to setup my action bookmark connected with selection from table in section A.