Dynamic Date Filter

[arpitutrivedi]

I want to populate dropdown filter values based on session. 

How do I do that?

[arpitutrivedi · Accepted solution]

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]

Hi @arpitutrivedi,

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

Best Regards,
Qiuyun Yu

[arpitutrivedi]

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]

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]

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