Forum Discussion
Card to display blank unless filter selected
- 2 years ago
You could write some formula that returns blank unless something is selected in the slicers. Something like
if(isfiltered(table[column]) && isfiltered(table[column]) && isfiltered(table[column])),<your formula>,blank())
or read my article here about hiding visuals.
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
You could write some formula that returns blank unless something is selected in the slicers. Something like
if(isfiltered(table[column]) && isfiltered(table[column]) && isfiltered(table[column])),<your formula>,blank())
or read my article here about hiding visuals.
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
Does this method still work? I have not been able to use measures as filters on cards or multi row cards.
- elkhawase1 year agoFrequent Visitor
it's a known issue that the cards doesn't allow filters
as a workaround, we can use a workaround as 2 measures to make the font and the background of the card transparent if nothing is selected.see full solution here
Dynamically Hide a Card - Data Visualizations - Enterprise DNA Forum