Forum Discussion
Pie Chart
- Anonymous3 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.
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.