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 ...
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

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

      Here is a quick question need your help.

      How can i adjust it? I have over 1 million clumns.

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

        Hi Damon,

        You need to make sure your tables have the same data structure, then you could refer to my former answer to union your tables.

         

        Regards,

        Daniel He