Matrix Table Transpose Rows represent column and Column represent Rows with multiple data type $,%

Hi NehaSha ,

Not sure how you have your data setup but if your matrix table looks like the first one you show, select the options on the matrix visual and go to values, then turn on the option Show on rows, the values that you have as values will appear in rows instead of columns.

Be aware that your Actual / PY column needs to be in columns and not on rows.

Regards,

MFelix

Hi NehaSha ,

You can add a column to each table refering to  Category (Acctual / PY), then rename the columns on both table to the same name and make an append of the data into a single table, then you can use  the solution I gave.

Regards,

MFelix

Hi NehaSha ,

Looking at your data maybe the best would be to make structural changes to your data in order to have it in a different shape. However I know that sometimes that is difficult to do because you already have a lot done in your work.

Let's create the following measures:

Net Rent = SUM(Power_Query[NetRentTY])

Gross pot = SUM(Power_Query[GrossPot])

Total Area = SUM(Power_Query[TotalArea])

Auction percentage% = 
IF (
    SELECTEDVALUE( Power_Query[Type] ) = "Var Difference";
    CALCULATE ( [Net Rent]/[Gross pot]; Power_Query[Type] = "Actual" )
        - CALCULATE ( [Net Rent]/[Gross pot]; Power_Query[Type] = "LY" );
   [Net Rent]/[Gross pot]
)

Now use this measures on your matrix and choose on the values options Show on Rows.

This will allow to select more than one value on your slicer for location.

Check PBIX file attach.

Regards,

MFelix