Solved: Dashboard - filter based on user input, multiple f... - Page 2

Colin_Lough · 11-02-2020 05:43 AM

Hey everyone,
Spent the weekend trying to get this to work with no luck so would really appreciate your help. I’m trying to get a view of my data where the user can slice the data based on a number of filters that can be selected from dropdown options. I tried to solve via the help articles on slices based on user data and think I might be close.

I have a table called ‘New Legal obligations’ that has columns included such as Region (lookup based on country), Status (enum), Team name (enum) etc. I’d like to see a page where I can have the data on the left and filters for user to select on the right
I created a ‘filters’ table that includes the column header and the values from the 3 columns (status, region, team name, set as enumlist with validity as SORT(New Legal Obligations[Status])
I took a slice of the ‘New Legal Obligations’ table, called it ‘FilteredDataForDashboard’ and added a row filter condition:
AND(
if(isnotblank(Filters[Team Name]), in([Team Name], Filters[Team Name]), True),
if(isnotblank(Filters[Region]), in([Region], Filters[Region]), True),
if(isnotblank(Filters[Status]), in([Status], Filters[Status]), True) )
Created a ‘Filters’ view to show the ‘Filters’ table data to be used on a dashboard
Created a 'Pane for filtering view to be used on the dashboard, with data ‘FilteredDataForDashboard’
Created a dashboard called ‘Dashboard for filtering’ and added 2 views
a. Pane for filtering
b. Filters (I think I’m wrong here).

When opening the ‘dashboard for filtering’ from the menu view, I get the filters view to be details rather than the option to select which filter to apply to the data slice.

Would really appreciate your guidance.
Thanks

Steve

Use like this:

AND(
if(isnotblank(FiltersForCurrentUser[Team Name]), in([Team Name], FiltersForCurrentUser[Team Name]), True),
if(isnotblank(FiltersForCurrentUser[Region]), in([Region], FiltersForCurrentUser[Region]), True),
if(isnotblank(FiltersForCurrentUser[Status]), in([Status], FiltersForCurrentUser[Status]), True),
if(isnotblank(FiltersForCurrentUser[Priority]), in([Priority], FiltersForCurrentUser[Priority]), True),
if(isnotblank(FiltersForCurrentUser[Obligation Categories]), in([Obligation Categories], FiltersForCurrentUser[Obligation Categories]), True),
if(isnotblank(FiltersForCurrentUser[Primary Jurisdiction]), in([Primary Jurisdiction], FiltersForCurrentUser[Primary Jurisdiction]), True),
if(isnotblank(FiltersForCurrentUser[Applicable Countries]), in([Applicable Countries], FiltersForCurrentUser[Applicable Countries]), True),
if(isnotblank(FiltersForCurrentUser[Products Impacted]), in([Products Impacted], FiltersForCurrentUser[Products Impacted]), True) )

View solution in original post

Dashboard - filter based on user input, multiple filters