cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Conect two sheets to one report.

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!

2 REPLIES 2
Super User IV
Super User IV

Re: Conect two sheets to one report.

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?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Anonymous
Not applicable

Re: Conect two sheets to one report.

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:

Preg1.JPG

 

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors