Total column at the beginning of the matrix table

[henryco88]

Hi,

How can i put the total column at the beginning of the matrix table?

[Icey · Accepted solution]

Hi @henryco88 ,

Based on my test, it is not supported in Power BI currently. You can vote this similar idea: Table / Matrix: Total Column on first position.

In addition, you can try to achieve your requirements like so:

Sample table:

Category	SubCategory	Value
A	a1	1
A	a2	2
A	a3	3
B	b1	4
B	b2	5
B	b3	6

1. Create a table.

Table 2 =
VAR t1 =
    DISTINCT ( 'Table'[SubCategory] )
VAR t2 =
    ADDCOLUMNS ( t1, "Order", RANKX ( t1, [SubCategory],, ASC, DENSE ) + 1 )
VAR t3 =
    DATATABLE ( "Total", STRING, "Order", INTEGER, { { "Total", 1 } } )
RETURN
    UNION ( t3, t2 )

2. Create a measure.

Measure = 
VAR a =
    SELECTEDVALUE ( 'Table 2'[Total] )
RETURN
    IF (
        a = "Total",
        CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Category] ) ),
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( ALLEXCEPT ( 'Table', 'Table'[Category] ), 'Table'[SubCategory] = a )
        )
    )

3. Create a matrix visual.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@henryco88 , I doubt such option for column total