Forum Discussion

badger123's avatar
badger123
Resolver I
7 years ago
Solved

MS Text Filter Visual

I'm using the MS Text Filter custom visual which pulls from a text column "phrases". I have a table visual to display the phrases. Does any one know how I could make this table visual showing no rows (i.e. blank) by default unless something is entered into the text filter visual? Thanks! 

Tips and Tricks
  • MFelix's avatar
    MFelix
    7 years ago

    Hi badger123 ,

     

    One work around is to create the following measure:

     

    Filter =
IF (
    COUNTROWS ( ALLSELECTED ( Table1[Words] ) )
        < CALCULATE ( COUNTROWS ( Table1 ); ALL ( Table1[Words] ) );
    1;
    0
)

    Then add this measure to your visual filters of the table and select the option of Value = 1.

     

    Check PBIX attach

     

    Regards,

    MFelix

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi badger123 ,

     

    One work around is to create the following measure:

     

    Filter =
IF (
    COUNTROWS ( ALLSELECTED ( Table1[Words] ) )
        < CALCULATE ( COUNTROWS ( Table1 ); ALL ( Table1[Words] ) );
    1;
    0
)

    Then add this measure to your visual filters of the table and select the option of Value = 1.

     

    Check PBIX attach

     

    Regards,

    MFelix