Create a custom filter on dashboard using the a list of parameters

[Anonymous]

Hi Guys,

I am working on a Facebook dashboard where I pass a parameter in the power query mode and this udpates my tables and the corresponding charts get updated.

However, I want a way to allow my end user to choose from a list of given values and accordingly the charts on the dashboard should get updated.

Currently, I connect to facebook and use:

= Facebook.Graph("https://graph.facebook.com/v2.11/" & Page & "/feed?limit=100&fields=from,message,created_time,shares,picture&since=2017-01-01")

where Page is separate query where a enter the field for which, the facebook data should be fetched.

But, I want to move this ability into the dashboard for the end user as they do not have access to the Power query mode.

Looking forward for some awesome suggestions soon.  🙂