Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
how do make matrix for the following measures in a column
Revenue - 123123
Gross Profit - 24624.60
Gross Margin - 20%
Net Profit - 9234.225
Net Margin - 7.5%
Error came
The question is what design you would like to get.
If simple one where values are displayed as rows like:
Then your formula would be:
Gross Profit & Margin = 'Table'[Gross Profit] & " " & FORMAT('Table'[Gross Margin],"Percent") |
and
Net Profit & Margin = 'Table'[Net Profit] & " " & FORMAT('Table'[Net Margin],"Percent") |
If you want to achiev something else, please provide more details
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 44 | |
| 40 | |
| 29 | |
| 19 |
| User | Count |
|---|---|
| 202 | |
| 130 | |
| 102 | |
| 72 | |
| 55 |