Forum Discussion

Renit's avatar
Renit
Frequent Visitor
10 months ago
Solved

Hide or Show table visual based on data available

  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 visua...
Need Help
  • Renit's avatar
    Renit
    10 months ago

    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's avatar
grazitti_sapna
Super User
10 months ago

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]