How row and column filters work

If your dataset is particularly large or you want to make your project more engaging, a number of Flourish templates enable you to set row and column filters. 

Row filters

Row filters allow you to create a user-facing control that enables the user to switch between different categories based on the value populating each row. 

1

Let's start with a dataset that contains energy sources according to their carbon footprint for numerous countries, and also their income group.

Next, we need to add our column bindings. Low-carbon and fossil fuel sources will be the  Values and "column A", which contains country names will be the Labels.

To filter according to income group, you should bind column D to Row filter.

2

Once you do that, a selection filter appears that enables you to choose which income-level countries to display in the visualization. 

Series filters

In the Controls & filters options, you can enable a series/column filter. The selection is based on the columns used for the Value column binding. Here you can choose between a single-select and multi-select filter

Formatting

1

Back to the row filter options, various settings are available. By enabling Include "All", you can add a selection in the filter control that shows all the data.

You can also change its name.

2

The controls settings allow you to switch between different control types; a button, a dropdown and a slider. By enabling the advanced options, you can add a title, adjust the width and sort the controls.

TIP: If you want to create a timeline, the slider control type is a good option to visualize your date series data.

3

You can also change the text size, weight and height.

And, specify specific colors for the dropdown and its border.

4

For buttons, you can set the background color, the color when a button is selected, and also one for a mouseover. The same color customization can be set for the text of the buttons.

Below, you can see the effects of some of the color customisation options.

5

Screen real estate is always precious, so in case you need to, you are able to change the alignment of the controls. Additionally, you can also adjust the spacing between different control elements in case there are more than one and also adjust the order they appear in. 

TIP: Do you want to lock into view a specific control selection and this to be served by default to users? Add the project to a single-slide story.