Custom Table Visual

[id013]

Hi,

I'm looking to create a matrix visual where I have multiple measures on the same row but under a single column of year. I have 2 measures one that calculates total sales, and another that calculates total customers. Due to the structure of the dataset the only option I have is to create a specific measure for each.  

I have created 6 measures, 3 that show the sales totals for each of 3 stores and 3 that show the customer totals for each of 3 stores.

I would like to have the matrix structured as follows:

	Year
Store1	Sales	Customers
Store2	Sales	Customers
Store3	Sales	Customers

However, with show on rows the result is this:

	Year
Store1	Store1 Sales
Store1	Store1 Customers
Store2	Store2 Sales
Store2	Store2 Customers
Store3	Store3 Sales
Store3	Store3 Customers

I know I'm limited by my dataset and the structure, but is there anyway to get the desired format? 

Thanks

[chandravadana]

You can merge two measures in a single column visually (either vertically or horizontally) in a single click without any DAX. This can be achieved using Inforiver.

[id013 · Accepted solution]

I found an article that helped:

https://community.powerbi.com/t5/Desktop/Table-visual-Is-it-possible-to-dynamically-add-remove-colum...