MATRIX measures in rows with 2 versions

Question

Hello,&nbsp;I have several measures with the same setup (only difference is some are for TARGET version, some are for ACTUAL version) and I want to reorder a matrix table but I can not do it as I wish. Could you help me how to put measure with names in rows? I tried with the VALUE SWITCH TO ROWS option, but the problem with it is that it puts actaul and target below each other and I want them next to each other. Is it possible?This is 1 dax example:&nbsp;Thank you in advance!

samwiseowl · Accepted Answer

You could use enter data to create a table with a single column with 2 rows: Actual and Target.
&nbsp;
Put this in your Columns seciton of the matrix.
Create a measure for each of the 3 types:Sales =If(SelectedValue(table[type]) = "Actual", [Actual Sales], [Target Sales])Repeat for each measure and add them into values.Then use the Values - Options - Switch values to rows

&nbsp;
&nbsp;

Forum Discussion

Related content

Version control

Multiple measures in matrix by year

Measure required in Power BI matrix

Filter Matrix by dynamic measure without recalculating values (Hierarchy Matrix - Power BI)

Matrix table