Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Allowing users to search database table

I have a report that's currently linked to a database showing how much money has been spent with certain vendors over the past several years. I'm wondering if it would be possible to include a search box in my report that could allow a user with read only rights to search by vendor name, then perform a search in the database that returned all users that fit the string they entered grouped by exact name and possibly other categories that I've defined - like year/quarter/region/etc?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    You can create a slicer using vendor field, when user select specific value in the slicer, the visuals in the report page will be filtered according to the selection. There is an example for your reference.



    Regards,

    Lydia

  • McCow's avatar
    McCow
    8 years ago

    Hi Anonymous

    i tryed make another example on Anonymous solution. Look:

    1)2)

    Step 1 - without any searches

    Step 2 - beginning of typing "ac" (for ACME example), but will be found all content with this sequence of chars


    With [Ctrl] key you can select many related records at once

     

    Or it is wrong too?

    Best regards

     

     

     

     

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Okay looks like that may be what I was looking for - thanks to all in this string for the help. 

      • McCow's avatar
        McCow
        Icon for Resolver III rankResolver III
        8 years ago

        Anonymous with pleasure, enjoy

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    You can create a slicer using vendor field, when user select specific value in the slicer, the visuals in the report page will be filtered according to the selection. There is an example for your reference.



    Regards,

    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks but that doesn't really address my issue, which is getting around the different ways a vendor may be entered. For example say there was a company named ACME - that company could have been entered in the system as ACME LLC; ACME - LLC; ACME LLC.; California Project - ACME; ACME - California Project and they all would come through as unique vendors. Many times as you search you'd be able to see the different entries and select multiple, but in the case above you would probably not capture the 'California Project - ACME' entry. So what I really need to have happen is have a user enter "ACME", and have the actual search that Power BI performs be a CONTAINS search. I know this still isn't perfect, but it's an improvement. 

      • McCow's avatar
        McCow
        Icon for Resolver III rankResolver III
        8 years ago

        Hi Anonymous

        i tryed make another example on Anonymous solution. Look:

        1)2)

        Step 1 - without any searches

        Step 2 - beginning of typing "ac" (for ACME example), but will be found all content with this sequence of chars


        With [Ctrl] key you can select many related records at once

         

        Or it is wrong too?

        Best regards