cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
InSadly Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User IV
Super User IV

Re: User input to filter for website to get model response

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
Super User IV
Super User IV

Re: User input to filter for website to get model response

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

InSadly Frequent Visitor
Frequent Visitor

Re: User input to filter for website to get model response

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

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

InSadly Frequent Visitor
Frequent Visitor

Aaaaarrghhh!! Re: User input to filter for website to get model response

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?

Super User IV
Super User IV

Re: Aaaaarrghhh!! Re: User input to filter for website to get model response

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

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors