Forum Discussion
Need Help
Hi All,
need your help and suggestion in creating a matrix as shown below.
Regards
Nita
Hi Anonymous ,
For matrix visual, the first thing you need to understand is the meaning of three fields.
- Rows: When creating a pivot table, we have to drag and drop the column fields that are displayed in the rows. So, similarly, for this field of the Matrix, we need to drag and drop the columns that need to be summarized in rows.
- Columns: Like rows, the columns that need to be displayed as "columns" will be dragged and dropped into this field.
- Value: This is simply the "value column" that needs to be summarized. For example, "Sales Column", "Cost Column", "Profit Column", etc., depending on the requirements.
The fields can be presented in a more detailed way in the form of a hierarchy. For "value", you generally use the measure formula that you create according to your business needs.
You can refer to the following matrix visual creation, and related blogs.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous ,
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebcHi Anonymous ,
For matrix visual, the first thing you need to understand is the meaning of three fields.
- Rows: When creating a pivot table, we have to drag and drop the column fields that are displayed in the rows. So, similarly, for this field of the Matrix, we need to drag and drop the columns that need to be summarized in rows.
- Columns: Like rows, the columns that need to be displayed as "columns" will be dragged and dropped into this field.
- Value: This is simply the "value column" that needs to be summarized. For example, "Sales Column", "Cost Column", "Profit Column", etc., depending on the requirements.
The fields can be presented in a more detailed way in the form of a hierarchy. For "value", you generally use the measure formula that you create according to your business needs.
You can refer to the following matrix visual creation, and related blogs.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
