topic Re: How to show results only after entering data in Desktop

How to show results only after entering data

Anonymous — Wed, 24 Mar 2021 13:54:09 GMT

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?

negi007 — Wed, 24 Mar 2021 14:18:53 GMT

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

Anonymous — Thu, 25 Mar 2021 11:36:28 GMT

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.

v-robertq-msft — Fri, 26 Mar 2021 09:09:09 GMT

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 — Tue, 30 Mar 2021 05:17:23 GMT

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.