Forum Discussion
Dynamic Pie Chart Percentage
- 2 years ago
If someone can pinpoint my errorYou are using a pie chart.
In the vast majority of cases a pie chart is the wrong visual type. It is only applicable if no filters are applied, or if the data in that pie chart truly represents 100% of the data subject.
Consider trying out other chart types.
- Anonymous2 years ago
Hi zohra69 ,
As lbendlin said, pie charts work best when showing a limited number of categories to compare parts of a whole.
But you can try modifying the expression, something likeVAR TotalCost = CALCULATE( SUM('Fact_Astro_PU_ALL_ICB'[Actual Cost per 1000 ASTRO PU]), ALLSELECTED('DatesCalendar'), ALLSELECTED('DIM_Region') )
The ALLSELECTED function removes contextual filters from columns and rows in the current query, while retaining any other contextual filters or explicit filters. For detailed information, please refer to the document: ALLSELECTED function (DAX) - DAX | Microsoft Learn.If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you for your prompt response. the pie chart represents 100% data as the information derived from same table. Only difference is that my dates are from a different DatesCalendar table.