Returning blank rows/no data in a Table visual when a Text slicer is not active

[Multistrada_v4]

Hello Community,

I am a novice in Power BI and searched the Community but could not find an answer to my question.

I have a fact table “Exam data” that includes an “Email” column full of email addresses.

On a report page, I have a simple Table visual that gets several columns directly from Exam data, including the Email column.  There are no measures involved, the Table visual Columns point straight to the table.

I have a Text slicer on the page that also points to the Email column of Exam data, and it works well: if I type an email address in the Text slicer and click the right arrow, the Table visual only shows rows for the selected email.

What I would like to achieve, is to have the Table visual showing blank rows/no data when the Text slicer is not active.

Currently, when nothing is selected in the Text slicer all the rows get displayed in the Table visual, which is the expected behavior.

Conditional formatting: I have tried this to hide the values in the table, but I get erratic behavior - sometimes it works, sometimes not.

In the Table visual, I found conditional formatting under Cell Elements\Apply settings to\Series = column name \ Background color & Font color.  I used the simple measure below to check the filtering on the Email column and to match the font and background colors when 0.  

Is the email search active =

IF(

    ISFILTERED('Exam data'[Email]),

    1,

    0

)     

This measure works fine, I checked its value in a Card, it responds correctly to the Text slicer.   But the conditional formatting in the Table does not, at least not all the time.  I changed the font color several times, sometimes the Table visual responds, sometimes not.

This conditional formatting behavior is not my main concern, (well, if someone has an explanation that would be great), but I would much prefer to have a solution that simply blanks the data or return empty rows in the Table visual when the Text slicer is not active.

Thank you for any help you could provide.

[Multistrada_v4]

Hello,

I do not understand:

a) Why parry2k's reply has been accepted as the solution, because it is not the case.  parry2k's videos are great and most useful, however, they did not answer my question of how to blank rows in my table.

b) Who accepted the solution, especially when I reported that perry2k's reply was not what I was after?

c) I now have a real, working solution to my problem, that does exactly what I wanted.  But a solution has alreqady been assigned....

I could explain the solution here, which is actually fairly simple, but people are probably not going to read it, because there is already a solution assigned.

I did read this post How to Get Your Question Answered Quickly   thoroughly and entirely, and I am following the guidelines.  Yet I had assumed that it was the orginal writer of a post or question that would flag a response as "solution", not someone else.  Also, I assumed that a solution would be resolving the problem raised.

Obviously it is not the case.

If someone is interested in a solution that worked, let me know.

[parry2k · Accepted solution]

@Multistrada_v4 there are few ways to achieve this, check these videos on my channel:

Color transparency and conditional formatting is VERY powerful Part 1 - Power BI

Conditional Formatting and Transparency to develop user friendly reports Part II - Power BI

[Multistrada_v4]

Thank you parry2K, much appreciated, I will look at the videos.  Yet as powerful as it can be, conditional formatting is about showing/highlighting/hiding things, right?  In my case, I am more interested in getting blank rows in my table - assuming that is possible -, also because I do not want users to download or export data from the Table visual when it is not filtered.      

[Anonymous]

Hi @Multistrada_v4 ,

Did parry2K 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Multistrada_v4]

Hi,
Yes, understood, thanks for the tips, and I have read the guidelines.
Best regards.