Creating a scatter chart to which will show 2016/17 data using slicer

Question

so i have 3 metrics X/Y/colour coded,

I have my scatter set up however I want to add 2016 data to this what is the best way to do this please ?

v-chuncz-msft · Answer

Jay2077,
&nbsp;
The requirement is not very clear. You may drag [Year] to Legend.

jay2077 · Answer

Thanks only I want to be able to choose between the 2 years

jay2077 · Answer

PS can you have more than one attribute in a legend ?

v-chuncz-msft · Answer

Jay2077,
&nbsp;
You might&nbsp;select Unpivot Columns in the Query Editor or use&nbsp;UNION Function&nbsp;in DAX to make it in one column.

Forum Discussion