Forum Discussion
Text box or visual to hide a graph based on a filter
Had to deal with this for a client-facing PowerPoint export, tricky without bookmarks. One workaround that worked for me was layering a card visual with the warning message and using a measure like yours to control both its visibility and the transparency of the underlying graph via conditional formatting.
You can’t hide a textbox directly, but you can fake it using a card visual with no border and transparent background. Use the same logic to dim or blank the chart underneath by setting its data colors or title to white when the filter is triggered. Not perfect, but works reliably in exports.
Resolver IHad to deal with this for a client-facing PowerPoint export, tricky without bookmarks. One workaround that worked for me was layering a card visual with the warning message and using a measure like yours to control both its visibility and the transparency of the underlying graph via conditional formatting.
You can’t hide a textbox directly, but you can fake it using a card visual with no border and transparent background. Use the same logic to dim or blank the chart underneath by setting its data colors or title to white when the filter is triggered. Not perfect, but works reliably in exports.