Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

rolling 2 months donut chart

i want to show distribution of rolling 2 months promoters, detractors and passivers in donut chart but is not giving correct results. it should give 75 % for Promoters and 25 % for Passives .please see pbix file 

 

pbix file: 

https://drive.google.com/file/d/19JXQs2aBUTk4g6wvvCiRevSxRs3suzFr/view?usp=drive_link

 

 

 

 

Totalcustomersrolling =
CALCULATE([TotalCustomers],
DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-2,MONTH))
 
Promotersrolling =
CALCULATE([Promoters],
DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-2,MONTH))
 
Promoters = IF(
    ISBLANK(CALCULATE(COUNT(Survey[customer_id]),Survey[category]="Promoter")),0,
    CALCULATE(COUNT(Survey[customer_id]),Survey[category]="Promoter")
)
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi powerbiexpert22 ,

     

    Would you like the donut chart to display data from the past two months? If so, you could add a date filter to the visual and update the Values parameter to reflect a count of customer_id.

     

    Best Regards,

    Bof

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi powerbiexpert22 ,

     

    Would you like the donut chart to display data from the past two months? If so, you could add a date filter to the visual and update the Values parameter to reflect a count of customer_id.

     

    Best Regards,

    Bof