Forum Discussion
Yet another difficult Power BI question
Add another column to table containing the P&L listings. Add 1 for the summary items. 0 for the expanded items. Then use a slicer. Have it selected at 1 for the summary view. Unselect everything for the expanded view.
It's not a solution to the management because they want to be able to select something in the slicer, like a product, then be able to expand/collapse the P&L.
They thought the bookmark was pretty cool yesterday but after finding out it just's screenshot of a filter setting, they were not impressed.
Add another column to table containing the P&L listings. Add 1 for the summary items. 0 for the expanded items. Then use a slicer. Have it selected at 1 for the summary view. Unselect everything for the expanded view.