Forum Discussion
Filter pivot-chart
Hello, I have a pivot table and a chart linked to it. If I sort any column in the pivot table, the chart reflects the sort. But, filtering a column that contains prices so that only prices above 1...
I can filter by using slicers, but I don't want to display all data. I have 100 silces, and I want to display only the silces that has a value wich is "grater than.." somthing - this is something very simple in a pivot table, but how do I reflect it in the chart?
Do you want to filter on a value field? If so, click on the filter/sort dropdown in the row labels header of the pivot table and click on Value Filters. You can select options such as 'Greater than...' from the submenu.