Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!!
Solved! Go to 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
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
it's helpful! thank you so much
Thank you.
So your idea is combine 2 table into 1 right.
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
Here is a quick question need your help.
How can i adjust it? I have over 1 million clumns.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |