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.
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?
Community SupportHello 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.