Align data on one line in Matrix.

[EvH]

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.

[olgad · Accepted solution]

Sending and Receiving Plants have to come to the values section with the summarization first

[EvH]

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.

[olgad]

Hi, please turn your table into a matrix.

[EvH]

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