Forum Discussion
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 week in PBI file.
Thanks,
KV's
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 getThis is the link to the PBIX for your reference: https://drive.google.com/file/d/1O9SBD3efHRF608lyl7uaxQ2Ad0R3i_Qa/view?usp=sharing
4 Replies
- AllisonKennedy
Community Champion
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.
I need Target value one time in the last column, I don't want each column.
Thanks,
KV's
v-cazheng-msftCommunity Support
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.
- danextian
Super User
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 getThis is the link to the PBIX for your reference: https://drive.google.com/file/d/1O9SBD3efHRF608lyl7uaxQ2Ad0R3i_Qa/view?usp=sharing
