Matrix visual challenge

[powerbifuddaa]

Hi there, hope someone can help me with the visualization of my matrix.

I put my fields in like this:

Then, I get this result:

Does anyone know if I can have this result and how to do that?:

Thank you. Regards, Elmer

[audreygerred]

Hello! Yes, you can achieve something similar by utilizing field parameters. If you create a field parameter that has the measures you want to use in it, you can then add that and the dimension that you want to the columns well and add in any measure you want to the values well (literally, any measure you want can go in teh value well since teh field parameter is going to be what actually determines the measure that displays). The only difference between what you wanted and what you will get is that the measure name will appear on top of the dimension. Below is an example I did:

Here is what I have in the field wells `Name` (in the columns well) is the field parameter I built for my measures: 

See, only order quantity is in the values well, but the visual shows the meaures for order qty, sales, and extended amount because of the field parameter. Field parameters is one of my favorite features (along with calculation groups).

Here is an article I wrote about field parameters. In the article I used dimensions, but you can build yours with measures, like I have in my screenshot above.

The Field Parameter Edition – Power BI with Me

[powerbifuddaa]

Hi @audreygerred , I haven't figured it out yet. Can you perhaps share your .pbix so I can see what I do wrong? Thanx, Elmer

[powerbifuddaa]

Hi @audreygerred, I tried your solution. It didn't work out however. I got this:

This is normally so easy in excel.... 

Thanx for your refresh on parameters.

Kind regards, Elmer

[SamWiseOwl]

Hi @powerbifuddaa 

Not easily.

Easiest thing would be two Matrix next to each other and hide the first column of the second Matrix.

The hard way would be creating a new column with the names of the two measures in it.

Then use this in your coulmns and drill down to m/v.

Create a measure for each seperate calculation.

Write a measure that tests the current column value and returns the corresponding measure.

It would be nast and hard to maintain.

[powerbifuddaa]

Hi @SamWiseOwl, thanx for your reply. I tried Audrey's solution.