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: 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...

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.

User input to filter for website to get model response

4 Replies

GilbertQ
Super User
7 years ago
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.
- InSadly
  New Member
  7 years ago
  GilbertQ : Some are born geniuses, some achieve genius, and some have genius thrust upon them.
  Perfect! Just what I needed, thank you...
InSadly
New Member
7 years ago
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?
- GilbertQ
  Super User
  7 years ago
  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

Forum Discussion

User input to filter for website to get model response