Forum Discussion
Need to add margin and margin% row in Matrix visuals
Hi All,
I would like to show Margin and Margin% in row for matrix visuals.
Below total reference of below image
Can any one help here
Hi somsbkrish8591,
Thank you for reaching out in Microsoft Community Forum.
To display Margin and Margin % as rows in a matrix visual (rather than columns), you can follow this approach using a disconnected table and DAX measures:
Please follow below Steps to Show Margin & Margin % as Rows in Matrix;
1.Create a Disconnected Metric Table
Metric Selector = DATATABLE(
"Metric", STRING,
{
{"Margin"},
{"Margin %"}
}
)2.Create a Measure to Switch Between Metrics
Selected Metric Value =
SWITCH(
SELECTEDVALUE('Metric Selector'[Metric]),
"Margin", [Margin],
"Margin %", [Margin %],
BLANK()
)3.Build the Matrix Visual like below;
Rows: 'Metric Selector'[Metric]
Columns: Your desired dimension (e.g., Product, Region)
Values: Selected Metric Value measurePlease continue using Microsoft Community Forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan
5 Replies
- MFelix
Super User
Hi somsbkrish8591 ,
The image is not clear enough about your needs, however if I understand you want to show a % and the total value on the matrix in rows.
On the settings of the matrix search for Show on Rows you can turn it on and the measures that you use on your table will presented in rows.
Hi somsbkrish8591,
Thank you for reaching out in Microsoft Community Forum.
To display Margin and Margin % as rows in a matrix visual (rather than columns), you can follow this approach using a disconnected table and DAX measures:
Please follow below Steps to Show Margin & Margin % as Rows in Matrix;
1.Create a Disconnected Metric Table
Metric Selector = DATATABLE(
"Metric", STRING,
{
{"Margin"},
{"Margin %"}
}
)2.Create a Measure to Switch Between Metrics
Selected Metric Value =
SWITCH(
SELECTEDVALUE('Metric Selector'[Metric]),
"Margin", [Margin],
"Margin %", [Margin %],
BLANK()
)3.Build the Matrix Visual like below;
Rows: 'Metric Selector'[Metric]
Columns: Your desired dimension (e.g., Product, Region)
Values: Selected Metric Value measurePlease continue using Microsoft Community Forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
PavanHi somsbkrish8591,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.Hi somsbkrish8591,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.Hi somsbkrish8591,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Please continue using Microsoft community forum.
Thank you,
Pavan.
