go to the options tab in front of each object and select the edit option you want to perform.

filtering data in columns and charts

to filter a value in the prepare tab, you can click the options tab in front of any object.

step 1 − go to filter.

step 2 − in the filter option, you can select keep only or exclude values for a particular value.

step 3 − here, only one value is selected. accordingly, the visualization changes under the visualize tab.

step 4 − once filter is applied, it will come in filter panel in the prepare tab.

step 5 − it can be removed by clicking the x button in front of the filter. in a similar way, you can apply filter on a chart in visualize tab.

step 6 − click add filter and select a dimension or a measure to add a filter to the chart. (no keep only or exclude values option while applying filters in a chart).