Forum Discussion

CookieMonster's avatar
CookieMonster
Icon for Helper I rankHelper I
8 years ago
Solved

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 i...
  • sokg's avatar
    sokg
    8 years ago

    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???

sokg's avatar
sokg
Icon for Solution Supplier rankSolution Supplier
8 years ago

Try SELECTEDVALUE

 

 

can you show us the measures used in Multi-row Card and which column use in Text Filter????

  • CookieMonster's avatar
    CookieMonster
    Icon for Helper I rankHelper I
    8 years ago

    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?

      • CookieMonster's avatar
        CookieMonster
        Icon for Helper I rankHelper I
        8 years ago

        Text Filter is using the Field: AnimalType

        Multi-row Card is has the filter: AnimalType (All)

         

        And when I type in the Text Filter, it does filter the Multi-Row Card as expected, so that works fine, its just getting it to show nothing in Multi-row Card when the Text Filter is blank, im looking into that link now, just seems confusing to me until I learn and understand DAX and how to access it in Power BI