Pie Chart

[Anonymous]

Hello,

Does anyone know how to create this type of pie chart in powerbi?

Thank you

[Anonymous · Accepted solution]

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.

[Anonymous]

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.