Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Matrix Table - Target Value

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 we...

Need Help

danextian
5 years ago
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

Community Support

5 years ago

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.

Forum Discussion

Matrix Table - Target Value

Related content

Matrix table

Matrix table

KPI level matrix table

Matrix table in Power bi

Monthly Actual vs Target Matrix Table