Forum Discussion
Matrix visual challenge
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
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