Table(visual): Matrices on the Side(Left-to-Right) not Top-to-Bottom

[ovetteabejuela]

Is there anyway I could get B instead of A, A is the normal setup for the table, matrix visuals

[bblais · Accepted solution]

You could turn your measures into a dimension using the pattern discussed here:

View Solution in Original Post

Once this is done, you can add the measure name to the rows instead of the columns...

[bblais · Accepted solution]

For example, I created an inline static table with my measure names in it like this:

Metrics = DATATABLE("Measure",STRING,{{"Revenue"},{"Costs"},{"Gross Profit"}})

I already have separate measures set up for my revenue, costs, and gross profit.  I just added another measure I called Val that is basically a switch based on which measure name is filtered by the current row (when used in a matrix for example):

Val = SWITCH(LASTNONBLANK('Metrics'[Measure],1),"Revenue", [Revenue],"Costs",[Cost],"Gross Profit",[Gross Profit])

And then I created a matrix with state and Metrics[Measure] on my rows, date on my columns, and Val as the value:

[bblais · Accepted solution]

Yes, but you will need to specify the aggregation like so:

Val = SWITCH(LASTNONBLANK('Metrics'[Measure],1),"Revenue", SUM([Revenue FIELD not Measure]),"Costs",SUM([Cost FIELD not Measure]),"Gross Profit",SUM([Gross Profit FIELD not Measure]))