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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
tomperro
Helper V
Helper V

Hiding or display default information on a card visual

Is there a way to either hide or display "Not Required" 

I would like to hide the entire card, but can not figure out how to hide the entire card if there is no data found.

My other option is to display "Not Required" but would prefer to hide it. 

tomperro_1-1744654860773.png

 

 

1 ACCEPTED SOLUTION

Hi @tomperro ,

Thanks for reaching out to the Microsoft fabric community forum. 

 

Option 1: Use a Transparent Shape or Button + Selection Pane
Use the Selection Pane and Bookmarks to toggle visibility based on logic.

1.Create two states of the card:

One with data (card shows actual values).

One with “Not Required” (or is hidden entirely).

2.Overlay with a transparent button or shape where needed.

3.Use a DAX measure to control button or shape visibility: Unfortunately, buttons can’t be shown/hidden with DAX, but you can simulate it using a combination of bookmarks + selection pane.

4.Create a slicer/trigger field, and based on its value:

Use bookmarks to show/hide the visuals (card vs button overlay).

You can use Selection Pane (View > Selection Pane) to toggle visibility of visuals tied to the bookmark.

Option 2: Use Conditional Formatting for Transparency
If you still want to use the same card visual, here's a trick with conditional formatting + a shape/button:

1.Create a transparent shape or button on top of the card.

DAX measure :

ShowCardFlag =
IF(
ISBLANK(SUM('YourTable'[YourMeasure])),
0,
1
)
Then in the Selection Pane, you can manually show/hide the overlay shape or button based on your bookmarked filter view.

 

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

View solution in original post

8 REPLIES 8
v-dineshya
Community Support
Community Support

Hi @tomperro ,

Thanks for reaching out to the Microsoft fabric community forum. 

 

Here are two approaches depending on whether you’re using Power BI:

1. Use a DAX Measure to Control Visibility :
You can create a DAX measure that determines whether there is data or not, and then use that to conditionally format the card's transparency or display a blank string.

To Hide the Text (e.g., show blank instead of "Not Required"):

Create a measure:

CardDisplayText =
IF(
ISBLANK(SUM('YourTable'[YourValueColumn])),
BLANK(),
"Your Actual Label or Calculation"
)
Then use CardDisplayText in your card visual.

2. To "Hide" a Card Visual Using Transparency
You can use conditional formatting to set the background color and font color to fully transparent when there's no data.

Create a measure that returns transparency based on your data, like:

CardTransparency =
IF(
ISBLANK(SUM('YourTable'[YourValueColumn])),
"rgba(255,255,255,0)",
"rgba(0,0,0,1)"
)
Use this measure to conditionally format the font color and background color of the card.

This won’t remove the visual from the page, but it will make it invisible when there's no data.

3. Use a Visual-Level Filter:
If you want the entire card to disappear: Add a filter to the visual based on a measure or column.

Create a measure:

ShowCard =
IF(
ISBLANK(SUM('YourTable'[YourValueColumn])),
0,
1
)
Then set a visual-level filter on ShowCard to only show when it's 1.

 

In addition to that, please refer community forum thread.

Solved: Hide Card Visuals having "Measure" as a value fiel... - Microsoft Fabric Community

 

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

 

My issue is that I have a button overlaying my card.

Hi @tomperro ,

Thanks for reaching out to the Microsoft fabric community forum. 

 

Option 1: Use a Transparent Shape or Button + Selection Pane
Use the Selection Pane and Bookmarks to toggle visibility based on logic.

1.Create two states of the card:

One with data (card shows actual values).

One with “Not Required” (or is hidden entirely).

2.Overlay with a transparent button or shape where needed.

3.Use a DAX measure to control button or shape visibility: Unfortunately, buttons can’t be shown/hidden with DAX, but you can simulate it using a combination of bookmarks + selection pane.

4.Create a slicer/trigger field, and based on its value:

Use bookmarks to show/hide the visuals (card vs button overlay).

You can use Selection Pane (View > Selection Pane) to toggle visibility of visuals tied to the bookmark.

Option 2: Use Conditional Formatting for Transparency
If you still want to use the same card visual, here's a trick with conditional formatting + a shape/button:

1.Create a transparent shape or button on top of the card.

DAX measure :

ShowCardFlag =
IF(
ISBLANK(SUM('YourTable'[YourMeasure])),
0,
1
)
Then in the Selection Pane, you can manually show/hide the overlay shape or button based on your bookmarked filter view.

 

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

Hi @tomperro ,

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

Hi @tomperro ,

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

danextian
Super User
Super User

Hi @tomperro 

You can a shape with a background-matching color when certain conditions are met, or apply conditional formatting to make the card’s visual elements transparent based on specific logic.

IF(SELECTEDVALUE('Table'[Column]) = "not required", "RGBA(0,0,0,0)")

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Deku
Super User
Super User

You cannot hide the card

 

You could add a rectangle in front of it and apply conditional formatting when no data. Something like 

 

If( [your measure] = "not required", "f000000")


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!
Greg_Deckler
Community Champion
Community Champion

@tomperro Well, you could return like a space or something so that nothing shows up.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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