cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
InSadly
New Member

User input to filter for website to get model response

Hi, I want to allow website visitors to query a simple list of "Service ID#" to find a simple index score I've calculated. The only way I have seen to do this so far is with a slicer like this:slicer.PNG

 

The trouble is there are over 10,000 ID#s (and growing) - is there no way to input a 15 digit numeric serial number into a search field, as you can on the desktop?

 

Many thanks for looking... 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @InSadly 

 

What you could do, is in the new Filter Pane you could put in your column "id"

 

As I have shown below, when you put it into the Filter Pane and a user uses it, you can then see that users can input any part of the 15 digit string and it will then display the results.

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
InSadly
New Member

Well, it did work perfectly, and then I publish publicly so anyone hitting my website can see it (without a Power BI login) and the filter pane just disappears... is this to be expected or am I publishing it wrongly?

Hi there

Thanks for the kind words.

When publishing to web, that is one of the limitations.

https://docs.microsoft.com/en-us/power-bi/service-publish-to-web




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @InSadly 

 

What you could do, is in the new Filter Pane you could put in your column "id"

 

As I have shown below, when you put it into the Filter Pane and a user uses it, you can then see that users can input any part of the 15 digit string and it will then display the results.

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ : Some are born geniuses, some achieve genius, and some have genius thrust upon them.

Perfect! Just what I needed, thank you...

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors