I have a table similar to the one below, with contains in rows case_ID and different columns to the right. Each of those columns are necessary to analyze an specific KPI / metric (there are also common columns that are used for whatever metric is selected).
I need to find a way that based on a KPI selection in a slicer, in the matrix will only appear the columns related to that specific metric. It is also necessary that if in the slicer I choose two or more metrics, the columns related to those two metrics should appear in the matrix.
We already find a way doing unpivot columns, but the problem is that when we try to export the table to an excel file it was not possible to create a table in excel, as we only have attributes. Bookmarks is our last option as it has an impact on the PBI performance
| Case ID | Product | Resolution_Met | Resolution time | Creation date | Resolution date | Closure date | SLA Met | Country | Region | Hub |
| 123 | Printer | 0 | 3.4 | 2021/01/01 | 2021/01/06 | 2021/01/09 | 1 | US | AMS | 1 |
| 456 | PC | 1 | 2.3 | 2021/01/01 | 2021/01/06 | 2021/01/09 | 0 | Puerto Rico | AMS | 0 |
| 789 | Printer | 1 | 1.2 | 2021/01/01 | 2021/01/06 | 2021/01/09 | 1 | China | APJ | 1 |
