Forum Discussion
Align data on one line in Matrix.
Hi Everyone
Please refer to the Table and Visualizations, this relates to the movement of stock between two plants.
I need to display the data in a matrix on one line, see preferred visualization result, but the data is displayed on three lines, see current visualization result.
The Sending and Receiving Plants Columns are filtered on the G/L Class, “Stock”.
I created DAX Measures for Stock Value Sending Plant, Transport Receiving Plant and Stock Receiving Plant.
Not sure if this was addressed before but I did not find anything.
Your assistance will be appreciated.
Sending and Receiving Plants have to come to the values section with the summarization first
4 Replies
Hi, please turn your table into a matrix.
Hi olgad
Thank for your response but unfortunately the Matrix also do not work, see below.
When I add the Sending and Receiving Plants to Columns, the plants are elevated to the header and the values below. This might work for one record but not for multiple records.
See preferred way I would want to view the records
Sending and Receiving Plants have to come to the values section with the summarization first
Hi olgad
Thank you very much you directed me in the right direction. I created a table with a Distinc column for Purchase Orders and then linked it the main table.
