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

Need Help
  • 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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    So far, Power BI doesn't have this type pie chart. But you could create this pie chart with below two ways:

    1. Non code way: you could customize visual with charticulator

      For more details, you can read related document: Getting Started | Charticulator

    2. Need code: Create your data visualisations using the Power BI visuals SDK—an open-source, command-line tool based on NodeJS and available on GitHub.

     For more details, you can read related document:  Power BI Custom Visuals – Data Visualisation Tools | Power BI (microsoft.com)

     

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.