I am trying to create a table that shows the record quarter and value of that quarter for different categories like sum of Sales, sum of AOI, sum of AOI%, etc. I am looking for the quarter with the maximum sum of ___ (whatever category is in question). I created a sample chart of what it should look like in Excel, but I am trying to find a way to build this in Power BI. (also included sample data to hopefully make things understandable)
I am able to create individual tables for each category and find the maximum for that category, but I am having a spacing issue when inserting these tables into my report. I was hoping to find a way to create one table for all categories, as the spacing for this would match the rest of the report.