cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
badger123 Member
Member

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: MS Text Filter Visual

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: MS Text Filter Visual

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!