Use Slicer to filter columns

[Anonymous]

Hi guys,

I have a dataset which looks like this.

I need to filter the years column in table visual

So when i use a slicer the year columns should show in the table visual.

Date Range: (start year - end year)

The year columns should be show in the table

Dataset:

Country	2016	2017	2018	2019
India	2	1	5	1
France	4	3	6	1

[Anonymous]

I am using unpivot for one of the visual requirement.

But I have to represent this data for the requirement in: region 2016 2017 2018 format

[Ashish_Mathur · Accepted solution]

Hi,

Once you have unpivoted the dataset, create a matrix visual.  Drag Region to the row labels.  Drg Year to the column labels.

[HotChilli]

You can Unpivot the Year columns so that the data looks like:

Country Year Value