Forum Discussion
Text box or visual to hide a graph based on a filter
Hi,
I've really tried searching for a solution but there isn't anything that quite works for what I need!
I have graphs and cards that I need to hide based on a filter but I'd also like a text box to appear over the image when the filter is selected that says something like "Data isn't available for this *filter."
I've created a measure
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.
2 Replies
TomOsResolver I
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.
- Greg_Deckler
Community Champion
Riley22 Create a measure to control the color of the text. Use the additional color digits to control the transparency. #FF0000 is red and #FF000000 is 100% transparent red.
