matrix Visual-Totals in left

[Anonymous]

Hi All,

I have one requirement to create a matrix which shows the total in left.Plaese refer attached mock report sheet.I have tried all possible ways but no hope.

Can anyone help me on this.

Thanks,

Nitin

[Icey]

Hi @Anonymous ,

Can the workaround I provided meet your requirements?

Best Regards,

Icey

[Anonymous]

I hvae tried ur solution.But it works fine wenver we have one mesaure ,In my case I have 3 measures.In matrix its showing 3 layers

[Icey]

Hi @Anonymous ,

If you don't mind, share me a dummy PBIX file, removing sensitive information, and I will conduct specific tests to see if it can be achieved.

Best Regards,

Icey

[Anonymous]

@Icey,

I cant share the PBIX file as its have very sensitive information.But I have created one mock report in (page 2).Please look into that.

But there is no option to insert PBIX file

[Icey]

Hi @Anonymous ,

Please upload your file to OneDrive for Business and paste the link here.

Best Regadrs,

Icey

[Icey]

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.

[parry2k]

@Anonymous you should able to achieve by following:

- add first column on rows

- add divison column on columns

- assuming you have two measures, one for the current year and one for prev year, add these two measures on value

[Anonymous]

I dont have first column.The totals renamed as Company total.Instaed of getting totals in right end I need it in left

[parry2k]

@Anonymous not sure what you mean by you don't have first columns, what BU Level1 , Level 2 , Level 3. where these values are coming from?

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

I have did same way as you mentioned but totals are not coming in begining its coming in right end of visual

[parry2k]

@Anonymous hmmm, I see you want to total as the first set,  not sure if there is out of the box way to do that. Column totals are always at the last. I believe you should add idea on ideas forum to allow to change the column's total at the front or at the end.

I would ❤ Kudos 🙂 if my solution helped. ?