Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Not Showing % value in show as table

Hi Team,   I am facing below issue, I have used 100% stacked column chart, here in the report side it is showing the value and in brackets it is showing the % too. But while clicking on the show as...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    It is a good idea, while it is by design in Power BI for now. As a workaround, you can create a normal stacked column chart and create a measure as below to get the percentage to put on the visual.

    Percentage =
    VAR _product =
        SELECTEDVALUE ( 'Table'[Product] )
    VAR _customer =
        SELECTEDVALUE ( 'Table'[Customer] )
    VAR _part =
        SUM ( 'Table'[Revenue] )
    VAR _all =
        CALCULATE (
            SUM ( 'Table'[Revenue] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Product] = _product
                    && 'Table'[Customer] = _customer
            )
        )
    RETURN
        DIVIDE ( _part, _all )

    If the above one can't help you get the desired result, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards