Add TARGET column to KPI matrix

[mtrevisiol]

Hi everyone.

I am creating a matrix that shows the performance of the company, month by month, using some indicators/KPIs.
In the columns there are the month and year (from January of this year to the current month), while in the rows there are the various indicators (total sales, active customers per month, ...). The format of the columns is "YYYY-MM":

and this is the underlying data structure:

I would like to understand how to add a 'target' column, with a single value for each indicator, containing the target value for each measure:

Here is the pbix file: https://www.dropbox.com/s/ipcv3ojxveqojat/Matrix%20with%20target%20values.pbix?dl=0

Can anyone help me? many thanks in advance.

[CNENFRNL · Accepted solution]

[mtrevisiol]

This is exactly what I needed, THANK YOU!

[Amila133]

Hi, I also need to do the same, could you please help, I can not retrive what you have done to solve this by looking at this thread

[Anonymous]

Hi,
I think this thread can help you solve the issue: https://community.powerbi.com/t5/Desktop/Fix-Target-column-in-matrix-visual/m-p/1512960#M624335

[mtrevisiol]

Thank you, but the structure of my matrix is different and I cannot adapt that solution to my case.

In my matrix, columns represent "Month-year", while KPIs are in the Values field. The Rows field is empty...

[amitchandak]

@mtrevisiol ,

seems like you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

[mtrevisiol]

Thanks @amitchandak  for your help, but unfortunately even following this tutorial I cannot achieve the desired result, because the structure of my matrix is different.

If it were possible to associate the target value, for each indicator, with a 'fictitious' date preceding all others (e.g. 2022-00), perhaps I would find the solution.

The problem is that I do not know how to relate measure - target value - yearmonth to show a different target value in each row