Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Solved! Go to 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
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
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)")
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")
@tomperro Well, you could return like a space or something so that nothing shows up.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.