Pivot date problem

Hi everyone! I'm pretty sure that my problem could be solved through pivot or unpivot feature, but I encountered a problem that I wasn't able to fix.

My dataset looks like:

I need to show it transposed, like:

Using pivot feature, seems to be ok:

But the problem, as the date columns now (due to pivot action) are metrics, I need to select one by one to include it in the table. But as my query datasource every day will return new days ( it recover last 4 days metrcs ) , the "new date" included every day, appears not checked ( as you can see 30/05/2020), so doesn't appear in the table.

Is there any solution to do it ? I mean, I need to show always the days returned into my datasource, with no manually intervention.

My .pbix attached, with the original table ( a sample ) and the pivoted table as other

source: https://drive.google.com/file/d/19VX0qKjk25MgowRCIxjBf6MWZ9na_v6Z/view?usp=sharing

Thanks in advance,

Regards!