How to set a filter for a Chart via a dropdown field on a Dashboard

[Shyam1]

I have two views on my Dashboard

1. Filter Section with Fin year and Category
2. Chart

What to display data on a chart based on selection made in teh Filter Section - Fin year Drop down and Category Drop down.

Currently unable to set the selection from Fin year Dropdown in the Slice row criteria.

[Steve · Accepted solution]

Create a slice that uses the same data table your current chart uses. Configure the slice’s row filter expression to use the choices made in your Search view to filter the rows of the chart data. Reconfigure the chart view to use the slice.

See also:

help.appsheet.com

Slice Row Filter Conditions

Explore how to use row filter conditions to build different slices of data.

[Steve · Accepted solution]

Create a slice that uses the same data table your current chart uses. Configure the slice’s row filter expression to use the choices made in your Search view to filter the rows of the chart data. Reconfigure the chart view to use the slice.

See also:

help.appsheet.com

Slice Row Filter Conditions

Explore how to use row filter conditions to build different slices of data.

[Shyam1]

thanks for your reply. i tried to implement your suggestion.
My Chart is currently based of a Slice , however unable to add a Filter condition on the Slice Row filter to reference the Search View - Fin Year dropdown

[Aurelien · Accepted solution]

Hi @Shyam

Wrap the last part with ANY()
[Financial Year]=ANY(Search[Financial Year])

[Shyam1]

Aurelien:

ANY(

Awesome ! It works thanks