Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all,
I know there has been recent updates to the Matrix visual in Power BI, but I still find it frustrating that I cant have measures in rows and in columns?
How can I produce a Matrix with KPI's such as gross margin in the rows, and years in the columns? It's not allowing me to use measures in both
e.g Data layout
COL 1 Col 2 Col 3
FY20 Revenue 20
FY19 Revenue 25
FY19 COGS -10
FY18 GP 15
E.g. FY20 measure filters col 3 by FY20
It's difficult to explain how great Power BI is to senior management when it can't even do basic things that excel has been doing for 20 years....
OK, mate. Before you start using a tool, you should really spend some time to learn HOW TO PROPERLY USE IT and not force a square peg into a round hole. You wouldn't use a drill instead of a hammer, would you? These serve different purposes and they do it extremely WELL. Same is with Power BI, PQ, M and DAX.
The rule is that a matrix uses dimension attributes on its rows and columns, and inside it you can have measures whose values depend on the attribute selections. Right? Right. So, in view of this, ask yourself a question: What should I do to be able to put the years on the rows, then cross-join it with the names of measures I want to see and then have another column in which I'd show the values of the measures?
Well, first of all, you need a TABLE, not a matrix. Second, you need to have a parameter dimension that will hold the names of the measures you want to use. Then you need a DAX measure that will be aware of your selections in the parameter dimension. If you add this all up, you should be able to craft the solution.
Please, always remember to THINK LOGICALLY and always know the strengths as well as the weaknesses of the tools you use.
Best
Darek
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 14 | |
| 8 | |
| 8 | |
| 8 |