Power BI Table visual Formatting

[Jos13]

Hi,

I have a table with sales details of different products. When I drag required columns in the power bi table visual, I get following output.

Is it possible to get a visual like the following in power BI ?

Your help is much appreciated.

[v-gizhi-msft · Accepted solution]

Hi,

Please take following steps:

1)Try this measure:

Total = 
IF (
    ISINSCOPE ( 'Table'[Category] )
        && MAX ( 'Table'[Product] )
            = MINX (
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Category] IN FILTERS ( 'Table'[Category] )
                ),
                'Table'[Product]
            ),
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Category] IN FILTERS ( 'Table'[Category] )
        )
    )
)

2)Choose matrix visual, the result shows:

See my attached pbix file.

Best Regards,

Giotto

[amitchandak]

@Jos13 , Refer

If one of format fits in https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

I doubt you can get exactly.

Try creating a measure like this and see if isinscope can help

Sub Total = Calculate(sum(Table[Sales]), allexpect(Table[Category]))

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/