Forum Discussion

zohra69's avatar
zohra69
Frequent Visitor
2 years ago
Solved

Dynamic Pie Chart Percentage

Hi all I have spend 1 days banging my head with this issue in trying to fix the Dax coding. I want to create a dynamic pie chart that change % segment based on various filters selected.  the scenar...
  • lbendlin's avatar
    2 years ago
    If someone can pinpoint my error 

    You 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.

  • Anonymous's avatar
    Anonymous
    2 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 like

    VAR 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.