1 of 1 people found this helpful
So currently you are not able to use Filters/Quick-Filters across 2 different datasources, and so the only way is to use a parameter. You can send 'Action Filters' across data-sources (let me know if this is an option, and I can show you how).
Cross datasource filtering, as you describe, was announced as an up-coming feature at TC15...but we don't have a release date yet (TC15 was back in November, so shouldn't be more than a few months away at the most).
It's a big frustration! so can't wait to have this feature added
Hope this helps.
Now i am having region filter so i want to use in a different data source...like cascading filter but i dont want to use a parameter to acheive this?
...so the only way to get filters to work across datasources (until the new feature) is to use Action Filters. In the attached I have 2 datasources, SuperStore and Population by State. I've set up a dashboard, with a sheet using each datasource. I can then set up the action filter as follows
This way when I click on a Bar (from DS1) it sends the State as a Filter to DS2, and so filters the Map. You can also use CTRL to select multiple states
Unfortunately until the new feature, Parameters and Action Filters are the only way to send filtering across datasources.
You can use action filters for doing this.
Can i use CAscading filters
Can i use cascading filters
...by this I assume you mean, that if you select a Region, the 'next' filter will only show a list of the states in that region to filter on?
Yes you can, with the above mentioned restriction that you can only use Action Filters. As you can control what is sent via an Action Filter. You could create one sheet, which showed Region (say) and clicking on a Region would send a filter (via an Action) to another Viz, which (say was at state level) to only show the States in that Region. From the 'state' sheet you could click on a State to further filter the Viz...in this way you would achieve the affect of Cascading Filters.