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.
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!
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?
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!!
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 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |