Forum Discussion
Do not show data in Table and Multi-Row Card when Text Filter is empty
I have a Text Filter, a table and a Multi-row Card.
When I search in the Text Filter, only the relevent data is shown in the table and Multi-row Card, but when I clear the Text Filter, all data is shown in both.
I would like it so that when I clear the Text Filter, the table and Multi-row Card is empty, how can I achieve this?
1. Create a measure
MeasureToCheck = COUNTROWS(ALLSELECTED(Sheet1[AnimalType]))
2. Select table visual first and then click and drag that measure to visual level filter (see pic below)
and choose is 1.
3. Repeat 2 but first click row card.
So we have
then
and at the end
Are you ok???
Are you ok with this???
14 Replies
Try SELECTEDVALUE
can you show us the measures used in Multi-row Card and which column use in Text Filter????
Sorry im new to Power BI, can you expand on what you mean by try SELECTEDVALUE?
And what do you mean by 'measures used in Multi-row Card and which column use in Text Filter', do you mean what fields and filters?
You should use SELECTEDVALUE in all those cases when you need to read a single value selected in the filter context, obtaining blank or another default value in all other cases.
More info here
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
Yes show fields and filters
