Need your help!!! Slicer question

[Damon]

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

[v-danhe-msft · Accepted solution]

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]

it's helpful!  thank you so much 

[Damon]

Thank you.

So your idea is combine 2 table into 1 right.

[v-danhe-msft]

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]

Here is a quick question need your help.

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

[v-danhe-msft]

Hi @Damon,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

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