Forum Discussion

CookieMonster's avatar
CookieMonster
Helper 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???

CookieMonster's avatar
CookieMonster
Helper I
8 years ago

Examples can be downloaded from:

RawData Excel Sheet > https://drive.google.com/open?id=1t99ftzHDmf2DFU8eHIg6laL8UGDxUlyr

Power BI Report > https://drive.google.com/open?id=10WiaUl5iwxFD_cdGtrf0WMNrCLeLHScU

 

So...

 

In the Text Filter, if you type in Dog, only Dog's should show in table and multi-row card

In the Text Filter, if you type in Cat, only Cat's should show in table and multi-row card

If Text Filter is empty, then table and multi-row card should not show any data.

sokg's avatar
sokg
Solution Supplier
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???

  • CookieMonster's avatar
    CookieMonster
    Helper I
    8 years ago

    Yes this works perfectly and I understand how this works thanks.

  • frivasn's avatar
    frivasn
    New Member
    7 years ago

    Thanks!!! it was really helpfull, my head almost explotes trying to filter my pane!!

     

    Gracias! Casi colapso!

  • leahYan's avatar
    leahYan
    Advocate II
    6 years ago

    this is an awesome idea! comparing to selectvalue

  • Iamwedge's avatar
    Iamwedge
    New Member
    4 years ago

    Just wanted to say thanks for this solution. Whilst my scenario was slightly different it did help me to get on the right track. I had a 100% Stacked Graph visual and a multi-row card. I only wanted to show data in the card when a specific column of the Graph was selected.

    I adapted the solution, checking that the count returned by the Measure = 1 or greater than 1. When the count is greater than 1 set all the elements of the card to match the background colour, when the count is 1 then set the colours as required to display.

     

    This was for a Service Health dashboard requirement, dynamically populating a traffic light status indicator per application and displaying the underlying metrics when selected.