Forum Discussion

Damon's avatar
Damon
Regular Visitor
8 years ago
Solved

Need your help!!! Slicer question

Hi, I have an problem.

 

I currently created graphs based on data from 2018. now I have two new same data in 2017 and 2016.

totally, I have 3 quiries.

I want to see the year trend in graphs that i created and and have slicer that allow me to select the year. how can i do it?

 

Thank you!!!!

 

 

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi Damon,

    Based on my test, you could refer to below steps:

    Sample data:

    Add calculated column: Type="2017"

    Table 2017:

     

    Add calculated column: Type="2018"

    Table 2018:

     

    Union the two tables:

    Now you could see the result and use the slicer to show different data.

     

    Regards,

    Daniel He

7 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Damon,

    Based on my test, you could refer to below steps:

    Sample data:

    Add calculated column: Type="2017"

    Table 2017:

     

    Add calculated column: Type="2018"

    Table 2018:

     

    Union the two tables:

    Now you could see the result and use the slicer to show different data.

     

    Regards,

    Daniel He

    • Damon's avatar
      Damon
      Regular Visitor
      8 years ago

      Thank you.

      So your idea is combine 2 table into 1 right.

       

       

      • v-danhe-msft's avatar
        v-danhe-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Damon,

        Yes. And the two tables should have the same number of clumns, you could adjust your data structure to make the two tables union.

         

        Regards,

        Daniel He

    • Damon's avatar
      Damon
      Regular Visitor
      8 years ago

      it's helpful!  thank you so much