Display the individual multiple measure values under single column

[LearningPBIX]

Does anyone know how to create a single column in the existing power BI table for mulitiple measures. Rows are already available. 

Please note that I have limitations with creating a new table or new column or table view as I'm connected to a live connection.

Scenario - I need the individual measure values under the group ' Actual - MTD' under one single column. Right now if I select them all they are being displayed under several columns.

Thanks in advance.

[v-ssriganesh]

Hello @LearningPBIX,
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.

[LearningPBIX]

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 · Accepted solution]

Hello @LearningPBIX,
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.

[FBergamaschi]

I am not sure I understand your request, can you make a draw of some kind to show what you want to obtain?

[LearningPBIX]

.

[LearningPBIX]

So you see the individual values in columns A to J, I'm trying to bring all those columns under one single column so that I can compare those values against the 'Benchmark Column' and populate the 'MTD Variance column. Does that make sense?