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:
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.