topic Re: Display the individual multiple measure values under single column in DAX Commands and Tips

Display the individual multiple measure values under single column

Anonymous — Mon, 30 Jun 2025 12:05:17 GMT

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.

Re: Display the individual multiple measure values under single column

FBergamaschi — Thu, 26 Jun 2025 17:26:14 GMT

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

Re: Display the individual multiple measure values under single column

v-ssriganesh — Fri, 27 Jun 2025 09:28:55 GMT

Hello 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.

Re: Display the individual multiple measure values under single column

Anonymous — Fri, 27 Jun 2025 13:11:17 GMT

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?

Re: Display the individual multiple measure values under single column

Anonymous — Mon, 30 Jun 2025 12:05:44 GMT

Re: Display the individual multiple measure values under single column

Anonymous — Fri, 27 Jun 2025 13:25:29 GMT

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?

Re: Display the individual multiple measure values under single column

v-ssriganesh — Sun, 29 Jun 2025 15:36:54 GMT

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.