Create row based data so table matrix can be created
I need to create a table that looks like the below but I can't because my data is structured differently
Output I want:
How my data is structured:
The 2 metrics listed are calculated measures for the actuals and for the targets they are all seperate metrics so my data doesn't know that Quote Start actual and Quote Start Target link up to make the table look like the above. I read about the power kpi visual and it says you have to have your data structured as row based? Is there a way to do this or an alternative to the power kpi visual? Thanks!