Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator
Creator

Alternate states But One single filter should work across the dashboard

Hi,

 

We have 4 sheets developed.

 

In sheet 1. we have developed the Heatmap and Only Year field has to work on the heatmap and even the year, it should work accross the dashboard.

To the year Filter we have Enabled in such a way that only one value can be selected by the user.

 

In sheet 2, sheet 3 and sheet 4.

 

we have almost 20 + filters and it shouldn't work on the Heatmap sheet(Page 1)

 

Can anyone help me on this Please

 

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Option 1 )   Apply the Year Filter via  a button Action

Allow user to filter Year values from a Variable then Add 4 Actions One for each State to apply the Year filter on

 

Option2) Apply Set Analysis on All Measures  via a filter that consider Year value selected in the default state

 

Option1  is the simplest and fastest way to get this done

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

Option 1 )   Apply the Year Filter via  a button Action

Allow user to filter Year values from a Variable then Add 4 Actions One for each State to apply the Year filter on

 

Option2) Apply Set Analysis on All Measures  via a filter that consider Year value selected in the default state

 

Option1  is the simplest and fastest way to get this done

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.