How to apply local filter to remaining sheets in dashboard

Q&A
,
1

Hi Team,

I have a date local filter in dashboard, that filter only applied to single sheet in dashboard, but my requirement is that filter should be applied to all remining sheets, here my end user not allows to me used global filter, using only local filter.

please see the below screen shot for your reference

image
image1919×750 96.1 KB

please help me to this

Regards,

Chaitanyakumar

2

Hi @Cnagabhairava,

You can apply a filter to the entire dashboard by switching the ‘applied to’ section at the top:

image
image369×1114 44.1 KB

3

Hi Brett, thank you for your answer, but in this way, it will applied to all the sheets please see the below screen shot for your reference.

image
image1917×768 122 KB

4

Hi @Cnagabhairava,
Could you please clarify your request a bit further? In your initial post, you said that your requirement was for the filter to be applied to all sheets; are you trying to apply your filter to only specific visuals on each sheet and across multiple sheets?

5

Hi Brett, I’m confused about the real requirement, i.e Date Global filter should be applied to entire workbook (all 3 dashboards 1. User experience, 2. Service level, 3. Process Efficiency & Purchasing Compliance) except the particular 2 sheets (bottom sheets in screen shot), because we going to fix the date in those 2 sheets (bottom sheets in screen shot) and not allowed to end users to interaction of those 2 sheets (bottom sheets in screen shot).

So please help me to do this

please see the below screen shot

image
image1919×754 85.1 KB

Thanks

Chaitanyakumar N

6

Hi @Cnagabhairava,
Ok, so you’re looking to apply a visual cross-sheet but would still like the ability to pick which visuals on the sheet have the filter applied to them. Unfortunately that is a current limitation with filters as you’re able to apply to one sheet (and pick which visuals) or to just apply to more than one sheet. Once applied to more than one sheet, you lose the functionality of picking which visuals.
There is a fairly easy way to work around this though; Start off by building a parameter for each date filter that need to be used on visuals. Choose the middle section (apply to ‘single sheet’), that way you can choose which visuals get filtered.
Then, on your next sheet, build a control for the same parameter and go through the same process as above. If you link up your parameter controls to a field from your dataset, when you change the control on one sheet, the control on your second sheet will mirror the same selection. Which will give you the same functionality of choosing select visuals on each sheet to have controlled by the same filter.