Forum Discussion

Jos13's avatar
Jos13
Icon for Helper III rankHelper 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 followi...
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

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
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