Forum Discussion
Add TARGET column to KPI matrix
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.
7 Replies
- CNENFRNLCommunity Champion
- mtrevisiolHelper V
This is exactly what I needed, THANK YOU!
- Amila133New Member
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
- AnonymousNot applicable
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- mtrevisiolHelper V
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...
- amitchandakSuper User
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc