Forum Discussion

micahelw's avatar
micahelw
Regular Visitor
3 years ago
Solved

Matrix Report Layout - multiple dimension columns on single line

 Hi

 

I'd like to know if the following is possible. 

I have a matrix report and the columns are taken from a fact table called RentCharges.  This table has a list of different rent charges ( Rent, Service charge, Ground maintenance, Lift) for each property.  

 

I'd like multiple attributes from the property dimension table listed - i.e for each property, its full address is listed - and not for example just is property reference.

I know one way I could do this is create a new column in powert query (or dax) that concatenates the address together - but ideally I would like the fields to remain separate.

A screen shot of the type of thing I am trying t acheive is shown below.

 

Many thanks in advance.