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.
Hey,
I have the following situation:
Can I use these monthly figures in an overall report?
If so, do I create a separate PBIX for each month and link it to another PBIX? Or do I do everything in 1 file?
all tips on how to do this or good documentation on this topic are welcome
PS the source data file (xls) is 150MB, contains 650,000 rows of data
Thx
Solved! Go to Solution.
I would use an Append query to append all of your months together into a single table. You could use visualization filters to filter each visual on a page to be just one month.
Generally you would do that in a single PBIX file.
REmains the question: If I have results on different pages per month (every month has its own data source), how can I combine this on an overview page with results from different pages?
I would use an Append query to append all of your months together into a single table. You could use visualization filters to filter each visual on a page to be just one month.
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |