Forum Discussion
How to change Parameter setting using Selected Value from a Slicer Visual
- 1 year ago
Hello raymondwkmok - thanks for posting to the community. In order for 'bind to parameter' to be visible and work, the tables being filtered by the parameters must be direct query as opposed to import mode. At this time SharePoint is not supported as a direct query source without first syncing it with some other location such as Azure SQL then using that as the source. However, it is still possible for you to utilize parameters to limit the volume of data. Instead of using report slicers to select the values of the parameters, you can use on of these methods below. Please let me know if there is anything else I can help with for this.
From PowerBI Desktop: Home > Transform Data > Edit Parameters
From the PowerBI service: Dataset Settings > Parameters
From Deployment Pipelines: Dataset > Deployment Rules > Parameter Rules
The powerquery looks fine. What is the error you get?
And it would be helpfull to see the result of the #"Selected Store" step. Just put in the "in" clause....
I have no DAX experience, so can't help you there.