Include active slicer selections in table visual Excel export in a single click

Hi ANKamdeepu 

The cleanest native way to achieve a single-click export that bundles both your detailed report data and your dynamic filter summary into a single Excel file is to merge both components into a single, cohesive Matrix visual layout on a hidden or dedicated "Export" tab. Because Power BI's native export engine only extracts the specific data underlying a single selected visual at a time, you can design a Matrix where your CONCATENATEX filter summary measures are placed directly in the Rows or Columns field well as a top-level hierarchy header, while your actual detailed report columns populate the subsequent nested rows or values section. When users click "Export data" and choose the "Data with current layout" option from this unified Matrix, Excel will generate a single sheet that preserves the hierarchy, cleanly displaying your flattened field parameter and dimension filter strings right alongside the structured table rows in one shot. If a strict tabular format is required instead of a matrix hierarchy, your only other native option is to inject your CONCATENATEX summary string directly as an additional repeating measure column inside your standard Table visual; while this repeats the filter text on every row, it natively forces all data points into a single exportable visual block without relying on external automation or script tools.