Matrix Table - Target Value

[Anonymous]

Hi Team,

I have Matrix table and need to add Target value in the last column, I don't have idea, 
Can you help me.

This is Matrix Table , need to add Target last column but it show's each week in PBI file.

Thanks,

KV's

[danextian · Accepted solution]

Hi @Anonymous ,

I've done this in the past but this is a bit finnicky and a little advanced I would say. I made use of a disconnected table and additional tweakings in Power Query.  Using a dummy data, this is the closest I could get

This is the link to the PBIX for your reference: https://drive.google.com/file/d/1O9SBD3efHRF608lyl7uaxQ2Ad0R3i_Qa/view?usp=sharing

[v-cazheng-msft]

Hi @Anonymous 

For Matrix visual, it is difficult to fulfill your needs. You can change visual type from Matrix to Table, then create Measure to achieve it. If you still want to create Matrix, you need a table in which there is a column containing all items of column headers and then create a new Matrix visual with fields from this table.

Best Regards,

Caiyun Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@Anonymous  This is difficult with a matrix. You would need to create a measure for every Week, as well as a measure for every target, and add each to the matrix. You could also potentially create a Measure table using SWITCH and SUMMARIZECOLUMNS functions.

[Anonymous]

Hi @AllisonKennedy 

I need Target value one time in the last column, I don't want each column.

Thanks,

KV's