Matrix visual challenge

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.

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