TEXTFilter to work on multiple fields

[YJ]

Hi there,

I have been working on the TEXTFILTER (from MS) and instead of the textbox returning all values when the TEXTBOX is empty, i want it to show the table to be empty till there is a text.

I have been trying to make this work: and got a partial solution from: https://community.powerbi.com/t5/Desktop/Visualisations-blank-until-something-selected-in-a-slicer/t...

From the suggestion in the above i create a measure:

CUPS_UNI_CHK = if(calculate(distinctcount(TestData[GROUPID]),allselected(TestData[GROUPID]))=1,"Y","N")

and put this as a filter in the visual level filter ( when contain "Y")

With one column

This works when i have only one column: GROUPID ( even this does not work always in the case of "A1", i believe cause of the existence of "A11")

However when i added a 2nd column, for example CODIDIOMA, it works but for some columns like CODCLI it does not work anymore ( see below)

with more then 2 columns

Can anyone explained why it doesn't and how best to resolve this??(pbix file below)

https://drive.google.com/open?id=1couzM85XXfm-bhIgAiEkgbSsi3cR8mU0 

Thanks

Sk

[Icey]

Hi @YJ ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @YJ ,

I do not know how to solve it. But there is one workaround to refer: Show or Hide a Power BI Visual Based on Selection.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.