Forum Discussion
Display the individual multiple measure values under single column
Hello Anonymous,
Thanks for clarifying. yes, I understand your requirement.In Power BI, especially when working with a live connection, measures are designed to show in separate columns by default. The “Show on rows” option can stack them into a single column, but it also restructures the visual to use the measure names as rows, which is different from having them as values alongside your existing rows.
Unfortunately, Power BI does not currently offer a way to combine multiple measures into one single value column next to your row labels without modifying the model.
If you can edit the model or coordinate with your data model owner, one common approach is to create a single measure that uses SWITCH() to return the correct value per row. This requires having a dimension table in the model and edit access to create the measure.
If you are fully constrained to a live connection with no model edits, this specific layout is not achievable out of the box.
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a "kudos" to help others locate it easily.
Thank you.
Community SupportHello Anonymous,
Thank you for reaching out to the Microsoft fabric community forum.
You can achieve this using a Matrix visual:
- Add your measures into the Values field.
- Turn “Show on rows” = ON in the Matrix formatting pane.
- This will stack all measure values under a single column, without creating any new table or column, fully supported in live connections.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Thanks for your response however the objective is to have only the values of those measures displayed under one column next to the existing rows. Does that make sense?
- v-ssriganesh
Hello Anonymous,
Thanks for clarifying. yes, I understand your requirement.In Power BI, especially when working with a live connection, measures are designed to show in separate columns by default. The “Show on rows” option can stack them into a single column, but it also restructures the visual to use the measure names as rows, which is different from having them as values alongside your existing rows.
Unfortunately, Power BI does not currently offer a way to combine multiple measures into one single value column next to your row labels without modifying the model.
If you can edit the model or coordinate with your data model owner, one common approach is to create a single measure that uses SWITCH() to return the correct value per row. This requires having a dimension table in the model and edit access to create the measure.
If you are fully constrained to a live connection with no model edits, this specific layout is not achievable out of the box.
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a "kudos" to help others locate it easily.
Thank you.