Hide or Show table visual based on data available

[Renit]

I have a three-page Power BI report. On the first page, there are Group and Month slicers, which are synced and used across the second and third pages.

On the second page, there are several visuals, including a table visual that displays one column from a table and two measures.

The requirement is:

• If the table visual has no data (i.e., it’s blank), it should be hidden.
• If there is data, the table should be visible.

To achieve this, I created a DAX measure that calculates a total, and if the total is blank, I set a flag. I then used bookmarks and applied this flag in the visual-level filter to control the visibility.

However, the issue is that when I change the Group slicer, the table visibility does not update dynamically based on the slicer selection.

I’m looking for a solution that ensures the table visual shows or hides dynamically based on the data returned by the slicer selections.

Any suggestions are appreciated

[Renit · Accepted solution]

I achieved this by using a slicer in the show and hide bookmarks, passing 0 and 1 values accordingly, and keeping the slicer hidden within the bookmarks.

[grazitti_sapna]

Hi @Renit,

 Power BI doesn’t natively provide an option to completely hide visuals (like a table) based on slicer or filter selections. However, you can create a similar effect — making the table appear invisible when no data is available — by combining a simple DAX measure with visual-level filtering.

Here’s how you can achieve this:

Create a Measure:
Create a measure that counts the no of rows based on the current slicer selection:

Table Row Count =
COUNTROWS (
    FILTER ( 'YourTable', --apply any filters if needed-- )
)

Now Apply a Visual-Level Filter

1. Add this measure to the Filters on this visual pane of your table view.

2. Set the filter condition to Show items when the value is greater than 0.

   With this setup, the table visual won’t display any data when there are no matching rows for the selection. However, the visual space will still be retained on the report page — it will just appear blank to the user.
   
   

   🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

   💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

   🔗 Curious to explore more? [Discover here]

[Renit]

But column headers of table will appear eventhough no data is available. How to handle this

[v-aatheeque]

Hi @Renit 

Power BI does not currently support completely hiding visuals or their headers dynamically based on slicer or filter selections. Even when no data is returned, the column headers of a table will still be displayed.

[v-aatheeque]

Hi @Renit 

Just checking in to see if the previous response helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.

[rajendranr1]

@ren 

 Bookmarks capture static state , its not dynamic. PBI doesnt support dynamic hiding/showing of data natively based on data presence. However, you can stack visuals to do workaround. Pls refer this link for the steps:

https://radacad.com/showing-an-alternate-text-when-no-data-available-in-a-power-bi-chart-visuals/

Thanks
Raj

[Ahmedx]

refer to the following

https://www.youtube.com/watch?v=lqPiYGoQxSw