I’m trying to create a filter with a few options selected by using the reportFilter object in slice. Similar to this example:
However, I’m now using an OLAP data source and I can’t get it to work. I changed one of your examples with Adventure Works. I’m trying to filter the Country on Canada:
But as you can see, it doesn’t filter on Canada. The filter shows, but all fields are selected.
Any idea what I’m doing wrong here?
Thank you for writing to us.
If you replace
[Geography].[Country].&[Canada], everything will be displayed as expected. Here is the example: https://jsfiddle.net/kk6ncpp2/1/
To be sure that you have defined members for filter correctly, we suggest configuring report filters via UI. Then you can save the report by clicking Save button in Toolbar and use this report.
Please let me know if you have any other questions.
That works, thanks. Good tip too!