Looking up values of different slicers, depending on row variable, into a single data column

[Anonymous]

We are trying to create a dashboard to visualise sales and targets of different variables, with users having the ability to enter in custom targets using slicer (different for each variable).

The idea was that there would be a slicer for each variable, which would then be all be read by and combined into a single column in the data tab for further calculations.

Below I've included an example which hopefully illustrates this problem better.

Any help with achieving this very much appreciated, or if anyone knows a better solution to this?

Thank you for reading 🙂

[mussaenda]

I don't know if this possible on dashboard but this is possible on rreport.

Povide sample data to test.

[Anonymous]

Thank you for your reply. 

The report would need to interact with the slicers on the dashboard, and be able to in a single column have rows reading off different slicers depending on the name of their variable.

Would this still be possible?