Forum Discussion
A help needed with structuring a table visual
Hello Power BI Community, I need a help with structuring a table and to do a variance analysis on product performance. (PL tab specifically) Sample BI data I would like the final table in P...
For the P&L drill-down layout with CY vs LY variance, the cleanest native approach is a Matrix with rows as your product hierarchy and columns as CY/LY measures. For the drill-through on variance column, you'd set up a separate detail page with cross-report drill-through.
One thing worth knowing: if brand managers need to explore different cuts of the data themselves (swap rows/columns, add DoD/MoM) without coming back to you, Flexa Tables (AppSource) handles this without rebuilding anything variance columns and period comparison are built-in, no DAX needed.