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

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