Forum Discussion

arpitutrivedi's avatar
arpitutrivedi
Frequent Visitor
8 years ago
Solved

Dynamic Date Filter

I want to populate dropdown filter values based on session.    How do I do that?
  • arpitutrivedi's avatar
    arpitutrivedi
    8 years ago

    I found a solution for this using query string filter. 

     

    Unfortunately, it allows only one value but, I got a workaround for that. 

     

    It would be nice to have In and Like filter besides standard eq filter. 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi arpitutrivedi,

 

Which "session" do you mean? Could you clarify your requirement? 

 

Best Regards,
Qiuyun Yu

arpitutrivedi's avatar
arpitutrivedi
Frequent Visitor
8 years ago

 

I want to make industry dropdown in below report dynamic based on which user is logged in. I want to pass user id in query string and based on that, Industry dropdown values should be populated. 

 

 

  • muchinski's avatar
    muchinski
    Resolver II
    8 years ago

    Hello arpitutrivedi,

     

    i felt in a similar problem some days ago and i could workarround that using the Roles feature. There (and in measures) are the only place we can use the USERNAME() function.

    Maybe this is exactly what you want.

     

    You can create a role for your users and limit there which Industry they can see.

     

    If you want a solution more dynamic, read this article from Kasper de Jonge

     

     

     

    • arpitutrivedi's avatar
      arpitutrivedi
      Frequent Visitor
      8 years ago

      Hello muchinski,

       

      Thanks for Your reply back.

       

      I am wondering if You could help with this task. Please let me know how much it would cost to complete this small task.

       

      My skype id is arpit_ace

       

      I hope we are allowed to work like that and we are not breaking any norms of this website. 

       

      Regards,

      Arpit