Forum Discussion
Use Slicer to filter columns
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 |
Hi,
Once you have unpivoted the dataset, create a matrix visual. Drag Region to the row labels. Drg Year to the column labels.
3 Replies
- HotChilli
Community Champion
You can Unpivot the Year columns so that the data looks like:
Country Year Value
- Ashish_Mathur
Super User
Hi,
Once you have unpivoted the dataset, create a matrix visual. Drag Region to the row labels. Drg Year to the column labels.
