Forum Discussion
TEXTFilter to work on multiple fields
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/td-p/109790
From the suggestion in the above i create a measure:
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
2 Replies
- IceyCommunity Support
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.