Group measures into columns in matrix?

[jd8766]

Hi, I have some measures like the below that relate to different areas of the business.. I want to display these in a matrix visual so they are grouped by the department they relate to but I can't figure out the best way of doing this.. or if it's even possible? Can anyone advise?

[Anonymous · Accepted solution]

Hi @jd8766 ,

According to your statement, firstly, [Day] and [Column] should look like as below.

I think [Total Sales]/[Total Cancellations]/[Total Leads]/[Leads Cancelled] should be measures. If you add four measures into matrix value field, Sales and Leads in column will be expanded by those measures. Then both Sales and Leads will be expanded to show fours measures. 

Here I suggest you to turn off text wrap and then reduce the width of columns you don't need to 0.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[speedramps]

We want to help you but your description is too vaugue. Please write it again clearly.

You have not provide any "department" data, tables, columns, relationship or measures.

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming