1 of 1 people found this helpful
It is difficult to be exact without seeing a workbook (if you are able to post a mock-up of your situation I can be more precise). However, there are some likely causes for this...
The most likely cause is that the dimension(s) you are sending, via the action aren't in the source sheet for the action (or for highlight actions aren't in the target)
So in below viz...in which I have a line chart (sales over time by Region), and a bar chart showing sales by sub-cat (stacked by Segment)
If I just use the 'Use As Filter' on the line viz, it sends ALL DIMENSIONS to the bar Chart, and so will include both the Region and the Date. However if we only wanted to send the Region (and not the time part), we can set the Action up ourselves and then control what is sent (in the below I'm only sending Region, and not the date part...and Region has to be in the 'source sheet')
With highlighting the 'sent dimension' needs to be in both sheets. If I tried to set up a highlight filter like the below image
It would try to highlight Region in the Bar, but can't find it (as we only have Sub-Cat and Segment) and the result is to gray out the whole view.
Sending dimensions actions between dashboards works in the same way, but you change the Target sheets to a different dashboard.
As I said hard to be exact, but I would first look at what dimensions are being sent and that the dimension is in the source sheet (for filters) and both (for highlights). If you can post a mock-up of your exact situation I'm happy to take a look.
thank you very much for your answer.
And I am really sorry to respond so late :-(
Issue is, that workbook is confidential and I tried to recreate a sample workbook, but it was really busy.
But your answer already helped me.
Thank you very much,