How to show results only after entering data

[Anonymous]

HI,

I'm thinking of something like in Reporting Services, when you put @value in where, the report would show, a blank field on the filter.

Is there a similar way for PowerBi for text type data?

[v-robertq-msft]

Hi, @Anonymous 

As far as I’m concerned, the only way to achieve this function like in Power BI is the “Search” in the Power BI Slicer, you can take a look:

Create a slicer and place the column [cod], then click like this:

Then you can enter a value to search and filter the data of [User], like this:

And you can get what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Hi,

Problem is, operator report will see number in Slicer, the report must be a with out anything.

So, solution ok, but not in my case.

[negi007]

@Anonymous do you want to use a measure output in the filter. Please share your problem with an example and data

[Anonymous]

ok,

select * from user

In Reporting Services I used select * from user where cod=@cod, and I get it:

If I do not enter anything, the report is empty. When I enter for example 333 in the table it shows user (b).

And now can I do something similar in PowerBI.