Forum Discussion

Jay2077's avatar
Jay2077
Icon for Helper III rankHelper III
8 years ago

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

Creating a scatter chart to which will show 2016/17 data using slicer   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 w...
Need Help
Show and Tell
Tips and Tricks
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Jay2077,

 

The requirement is not very clear. You may drag [Year] to Legend.

Jay2077's avatar
Jay2077
Icon for Helper III rankHelper III
8 years ago

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

  • Jay2077's avatar
    Jay2077
    Icon for Helper III rankHelper III
    8 years ago

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

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Jay2077,

       

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