Forum Discussion

Jos13's avatar
Jos13
Helper III
6 years ago
Solved

Power BI Table visual Formatting

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.

Data Protection
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

2 Replies