Matrix and Tables - multiple measures layout question

[MattAllington]

I want to create a simple table visualisation in Power BI as follows

Measure 1  $123

Measure 2 1,304

Measure 3 etc

When I put 3 measures in a table, It give me this.

Measure 1     Measure 2      Measure 3

$123                1,304              etc

Same happens when I use a matrix.

Is it possible to have the measures appear down the page rather than across the page?  If so, how?

Thanks

[gama_thais]

Hi! Is there a solution to this?

Thank you in advance

Thais

[MattAllington · Accepted solution]

For those that agree this needs to be fixed, please vote for it here

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...

[Sean]

VOTED!

If anyone wants to also see Collapse/Expand Buttons in the Matrix - here's a link to my idea...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

Thanks!

[Sean]

A Multi-Row Card would be the only way I could think of.  You have to make it wide enough to fit only 1 Measure though

And if you don't like that line on the left side you have to cover it up with something - no show/hide switch for it

[MattAllington]

Thanks Sean.  Wow, this is a big gap.  I know there is a stack of work going on with Tables.  Hopefully that will be released this month, but I don't know if this will be addressed.

I am currently looking into a switch measure off a disconnected table as a way to solve this.

[karthik]

You are correct - the table and matrix functionalities are very limited in Power BI. I did see few improvements when they showcased features around conditional formatting etc. in the recent Data Insights Summit. However, we are not sure when these would be released. Even if these features get release, they still have a long way to go offer the same flexibility as Excel pivot tables.

You are on the right track in creating a disconnected table and using "switch" to apply the calculations. However, we had few issues with this approach mostly around formatting as you can have different format strings for different measures ($, Units, % etc.). You could use the format function in DAX but this would convert each of your measure to a text. It's not flexible as you need to expand the "switch" statement everytime you add a new measure. Also, there are limitations in few use cases around charting, e.g. when you want to use a combo chart/scatter chart (or any other chart which would require more than one measure) you wouldn't be able to use the measures from you "Measure" dimension (disconnected table).

Thought I'd let you know the limitations based on our experience using a similar approach (just in case you are not aware)

[MattAllington]

Thanks @karthik and @Sean.  I agree with all your comments.  I find it useful to double check here in case there is something otherwise overlooked.   Your comments are consistent with my findings.

[Sean]

I hope you are right about the Tables - still lots of work needed there - nowhere near a good old fashioned Pivot Table

Lets see what we get with the April Update