Hey All -
I have report that I recently transitioned to Power BI, and thus have a tabular data set. I'm hoping to transition the old excel report, which was a bunch of sumifs in a table, and replace it with multiple pivot tables on the same sheets.
The issue comes with expanding/collapsing pivots, a few of the pivot tables will have monthly data and I would like to incorporate slicers to filter by month or quarters, thus changing how many columns a pivot takes ups. Has anyone found a workaround to allow these pivots to be both filtered and still presentable (I don't want a 9 blank column between the tables)?
I was wondering if there's a macro that hides blank columns automatically or possibly paste the pivots to another range?
I attached a very rudimentary spreadsheet with this issue.
Thanks,
Bookmarks