matrix Visual-Totals in left

Hi Anonymous ,

Power BI doesn't support to set "Total" to left currently.

Here is a similar idea which you could vote it up: Move Sub-Total and Total columns to left side.

One workaround, you can create your Measures like so:

1. Fact Table: 

2. Enter a table:

3. Create Measures.

Current Year = SUM('Table'[Value])

Last Year =
VAR ThisYear =
    MAX ( 'Table'[Year] )
RETURN
    CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = ThisYear - 1 )

Measure = 
VAR ThisYear =
    IF (
        MAX ( 'Year & Measure'[Year] ) <> "All Years",
        VALUE ( MAX ( 'Year & Measure'[Year] ) )
    )
RETURN
    SWITCH (
        TRUE (),
        MAX ( 'Year & Measure'[Year] ) = "All Years"
            && MAX ( 'Year & Measure'[MeasureName] ) = "Current Year", [Current Year],
        MAX ( 'Year & Measure'[Year] ) = "All Years"
            && MAX ( 'Year & Measure'[MeasureName] ) = "Last Year", [Last Year],
        VALUE ( MAX ( 'Year & Measure'[Year] ) ) IN VALUES ( 'Table'[Year] )
            && MAX ( 'Year & Measure'[MeasureName] ) = "Current Year", CALCULATE ( [Current Year], 'Table'[Year] = ThisYear ),
        VALUE ( MAX ( 'Year & Measure'[Year] ) ) IN VALUES ( 'Table'[Year] )
            && MAX ( 'Year & Measure'[MeasureName] ) = "Last Year", CALCULATE ( [Last Year], 'Table'[Year] = ThisYear )
    )

4. Create a Matrix visual.

For more details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.