Conect two sheets to one report.

[Anonymous]

Hello!

I've a report which is imported from Google Sheet and I want to do a graph which can join the data from the diferents fields (which are the same in all tabs).

For example:

I've two tabs: Course1 and Course2. And I want to create a graph that can Join the two course and the create a slicer from which i can select only one option to see the KPIs.

Thanks!

[Greg_Deckler]

I may be missing something here, but it sounds like you either need to create a relationship between your two tables or append them together. I am assuming that you have a separate query to import each tab of your Google Sheet?

[Anonymous]

Hello! Thanks for the response. 

Yes, I don't know if I should create a relationship, append fields or create a calculated columm. Because, in the near future,I'm going to add new course so I've to plan a model that can resist this changes without break the report.

This is an example:

I want fields in MKT01TN y MKT02TM feed one graph and then I can choose whit an slicer the propper course.

I hope I have explained clearly my doubt

Thanks!!