[SOLVED] Peculiar filtering in a pivot table I can solve

Hello,

Here is a simplified example of my problem (see sample in attachment). I have several tables. Each one contains data for one month. In the screenshot, the table (on the left) stands for the synthesis created with Power Query.

I need to create a pivot table to have an overview of ids performance along the months. I want to have a slicer (or any other solution) to dynamically filter the ids according their presence in the chosen month (here for February for instance).

Currently, the slicer filters the months (only February column will be shown). That’s not what I need. I want to filter the ids according to months. Show only ids that are present in the given month but show also their perfs for the other months if there are. The screenshot shows what I want to accomplish but the sample file in attachment is even clearer.

I wrack my brain with power query and power pivot but I’m stuck. With power pivot, I can not create relation with another table that would contains only id and month because ids are not single.

How could I do that ? I can use power query and power pivot if needed.