Forum Discussion

raymondvanzon's avatar
raymondvanzon
Frequent Visitor
6 years ago
Solved

Using a slicer to choose between two columns

Hi,


I have some data i would like to visualize in a line chart. 
The data consists of values for different years, scenario's and policy's

In output 1 I have all data for policy 1, and in output 2 i have all data for policy 2

For my example's i used excel and created some random value's, so this is not my real output.

 

for example i have the following table (I have one tab for policy 1 and one tab for policy 2)

 

Now, i want to be able to make a line chart that visualizes the data. 

I want to be able to use a slicer to choose between year and scenario's. 

This i can manage as i unpivoted, which gave me the following output :


(the data continues for all years, so year 2, scenario 1......... all the way to year 60 scenario 2000)

I used excel to create the example above, in my real data the diferent policies are in different queries.

 

However, i would like to create another slicer that lets me choose between policies and will show the value's for the chosen policy in the chart.


For example, I want to look at scenario 1 for all year (this I know how to do) and i want to look at policy 1. I would like to switch between policies and look at scenario 1 for all year, but this time for policy 2.

At the same time i would still like to be able to filter between scenario's and years.

Can i create some filter that lets me switch between policies, while I also have different filters for years and scenario's?

all help is appreciated.

 

2 Replies