Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Srvs2705
New Member

Hide and show matrix based on the slicer selections

I have list of measures and dimension and im showing them in the 2 slicers. I have a matrix in which im showing all the list of dimensions and measures so whenever i make selection from the dimension and measure slicer the matrix should act dynamically based on selection but ntg nthing is selected a text should appear on the  matrix like "select atleast a measure and a dimension for analysis".When im doing this using a matrix and transparent card the headers are appearing on the card.Help me to sort out this.

Srvs2705_0-1754295419493.png

 

1 ACCEPTED SOLUTION
burakkaragoz
Community Champion
Community Champion

Hi @Srvs2705 ,

 

The headers showing through your transparent card is a classic Power BI annoyance. Here's what actually works:

Easiest fix - put the message inside the matrix: Instead of fighting with overlaying cards, just make your matrix show the message when nothing's selected:

Matrix Display = 
IF(
    HASONEVALUE(MeasureSlicer[Measure]) && HASONEVALUE(DimensionSlicer[Dimension]),
    [YourActualMeasure],
    "Please select both a Dimension and a Metric"
)

Use this as your matrix value - no overlay needed.

If you want the fancy show/hide approach:

  • Create a shape (not card) to cover the matrix
  • Set shape fill to match your background
  • Add text box on top of the shape with your message
  • Use bookmarks to show/hide matrix vs message

Why the card isn't working: Matrix headers have their own formatting layer that bleeds through transparency. Cards are notorious for this.

Quick hack: If you're stuck with the card approach, make the matrix headers the same color as your card background, so they're invisible when the card shows.

The "message inside matrix" approach is honestly the cleanest - one visual, no layering headaches, and it works every time.


If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.

View solution in original post

1 REPLY 1
burakkaragoz
Community Champion
Community Champion

Hi @Srvs2705 ,

 

The headers showing through your transparent card is a classic Power BI annoyance. Here's what actually works:

Easiest fix - put the message inside the matrix: Instead of fighting with overlaying cards, just make your matrix show the message when nothing's selected:

Matrix Display = 
IF(
    HASONEVALUE(MeasureSlicer[Measure]) && HASONEVALUE(DimensionSlicer[Dimension]),
    [YourActualMeasure],
    "Please select both a Dimension and a Metric"
)

Use this as your matrix value - no overlay needed.

If you want the fancy show/hide approach:

  • Create a shape (not card) to cover the matrix
  • Set shape fill to match your background
  • Add text box on top of the shape with your message
  • Use bookmarks to show/hide matrix vs message

Why the card isn't working: Matrix headers have their own formatting layer that bleeds through transparency. Cards are notorious for this.

Quick hack: If you're stuck with the card approach, make the matrix headers the same color as your card background, so they're invisible when the card shows.

The "message inside matrix" approach is honestly the cleanest - one visual, no layering headaches, and it works every time.


If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors