Are you able to post the workbook (twbx file)? So Your Question Didn't Get Answered...
Without seeing the workbook, one solution may be to create a second action that defines the specific data sources.
hey sorry m rising my question here bec m not getting exactly where to place my question can u pls let me know is der any way to get "pageno" for dashboard....i need to have proper nd correct page no wen i generate PDF for printing
I believe I have the same issue and can provide a workbook with dummy data.
I have a datasource (xls) with two tables: Milestones and Risks. The Milestones table is used to generate a visualization of project milestone dates, including date slippage. As such, the visualization is a dual axis chart, with Old Date and New Date as the key pieces of data. The delta between Old Date and New Date is the measure plotted to demonstrate milestone delay.
I have a second visualization using the Risks table to simply list out milestone-related risks.
I would like to be able to filter my Risks, based on the Milestone that they relate to. I want to construct a dashboard with two sheets, and use the Milestone visualization as a filter. I have joined the two tables, using Milestone ID as the foreign key. However, when I click on the milestones in the Milestone visualization, it returns no values in the Risks visualization. As an observation, when I have a single-axis Milestone viz (i.e. just displaying the current milestone date), the problem goes away – but it's key that I show both elements in my viz, and that clicking on the Milestone viz filters the Risks viz. I have attached the workbook using safe / dummy data for your reference.
I would really be grateful for the assistance as this is something of a showstopper.
Dual Axis filter problem.twbx 44.3 KB
I think if you add a target filter to the dashboard action you will get what you need. Click on the Milestone ID to filter the Risk sheet to those risks associated with that Milestone.
Many thanks Juliette - the solution works.