Using a slicer to choose between two columns

[raymondvanzon]

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.

[amitchandak · Accepted solution]

refer , if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[raymondvanzon]

I think i made it work. Thanks for your help.