Forum Discussion
Display the individual multiple measure values under single column
- 1 year ago
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.
I am not sure I understand your request, can you make a draw of some kind to show what you want to obtain?
.
- Anonymous1 year agoNot applicable
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?