Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Pie Chart

Hello,   Does anyone know how to create this type of pie chart in powerbi?   Thank you
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    There is a workaround for you, please try below steps:

    1. below is my test table

    Table:

    2. create measure with below dax formula

    Measure =
    VAR tmp1 =
        FILTER ( ALL ( 'Table' ), 'Table'[Year] = 2021 )
    VAR tmp2 =
        FILTER ( ALL ( 'Table' ), 'Table'[Year] = 2022 )
    VAR _a =
        SUMX ( tmp1, [Profit] )
    VAR _b =
        SUMX ( tmp2, [Profit] )
    RETURN
        DIVIDE ( - ( _b - _a ), _a )
    
    Measure 2 = 1-[Measure]

    3. add a Donut Chart visual with above measure, add a text box with some words

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    Pie Chart.pbix26 KB