Measure table

Hi

i need some help relating a table that is build with measures and the date table.

So, in my report i have information regarding kpis that are imported from excel in the format

date         kpi1 kpi2 kpi3
01/04/22   2     5      5
06/04/22   4     7     8
09/04/22   9     7     1

I've already calculated several measures to each kpis like count, sum, % of particular data (more than, less than, etc) and already have a relation between this info and the Date table (I'm using fiscal year table).

Now I need to do a visual like this

where in each column is presented different measures to each kpi.

the only way I was able to do so is by creating a new table using de calculated measures like

UNIOn (

ROW ("Name kpis", "kpi1", "measure 1", [measure 1], " "measure 1", [measure 1]) .....

but I'm not able to relate this table with the date so, although the visual is working is not possible to filter 😞

Can you help me?

thanks 

Melanie