show only data of the matching item in the search box

[sant]

I have a report that is currently linked to a database that shows how much money was spent with certain providers in recent years. I wonder if it would be possible to include a search box in my report that allows a user with read-only rights search by provider name, then perform a search in the database that returns grouped all users that fit in the chain that entered by name but when no search or text has been entered the report does not show any data.

Currently I am using a normal filter and I have also tested with the custom visual "Text Filter" but I have the problem that if no search is done it shows all the billing of the company and I do not want to show it.

What I want is simply a search engine by the name of the provider and that shows only info of the selected or matching item.

gracias

[v-frfei-msft]

Hi @sant,

We can take the following steps to meet your requirement.

1. Enter the data accordingly, and create the measures as below.

Measure = IF(ISBLANK(SELECTEDVALUE(Table1[provider name])),BLANK(),CALCULATE(SUM(Table1[money])))

SlicerCheck = if(calculate(distinctcount(Table1[provider name]),ALLSELECTED(Table1[provider name]))=1,"Y","N")

2. Then filter the table we create in advance, show the items when the SlicerCheck is Y.

For more detail, please check the pbix as attached.

https://www.dropbox.com/s/xib2qs6gmhbxzs4/show%20only%20d2.pbix?dl=0

Regards,
Frank

[sant]

Hi @v-frfei-msft

I see that when I share my report with third parties they can override the filter created and therefore have access to the total billing data. How can I leave the filter created always fixed?

[v-frfei-msft]

Hi @sant,

Based on my test, I suggest you to publish the report to web and share the link to the end users, then all of the end users can only see the content that you shared and they cannot edit the report any more. Please notice that everyone could view the report with the link. For more details, please check the online document.

Regards,

Frank

[v-frfei-msft]

Hi @sant,

Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

Regards,

Frank

[sant]

Hello,

certainly that is not the solution because the data would be publicly visible to anyone.

thank you anyway

you can read the following in the documentation you sent.

-----

Warning

When you use Publish to web, the report or visual you publish can be viewed by anyone on the Internet. There is no authentication used when viewing these reports. Only use Publish to web with reports and data that the anyone on the Internet (unauthenticated members of the public) should be able to see. This includes detail level data that is aggregated in your reports. Before publishing this report, ensure you have the right to share the data and visualizations publicly. Do not publish confidential or proprietary information. If in doubt, check your organization's policies before publishing.

-----