Forum Discussion
Problem with comparing two different years annual result in a clustered column chart
Hi AlexanderE,
Your issue is that you have your information in two tables. On the query editor do a append of the two table into one then you are abble to get the expected result, be sure before apending both table that you identifiy the year on each one.
Are you getting your information from what type of data source? Depending on the sources there are several resourcer on PBI that will allow you to append both table without big issues or programing.
Regards,
MFelix
Super UserHi AlexanderE,
Your issue is that you have your information in two tables. On the query editor do a append of the two table into one then you are abble to get the expected result, be sure before apending both table that you identifiy the year on each one.
Are you getting your information from what type of data source? Depending on the sources there are several resourcer on PBI that will allow you to append both table without big issues or programing.
Regards,
MFelix
Hello MFelix!
Many thanks for your reply! As i thought, the solution to the problem was simple. I did as you told med and created a append of the two tables with different of the years that i want to differentiate and it works just fine!
The data source is excel-files that are generated in FME (Feature Manipulation Engine) that i use in my work.
Again, many thanks!
