Forum Discussion

laurent_rio's avatar
laurent_rio
Helper I
5 years ago

Any Visual that can display multiple Pie chart ?

Hi ,

 

I want to display to two Pies chart at same visual where the x axis will be time, for example like comparing resign reason for period 2020 vs 2021 like this :

Is there any visual in Power BI can do this ?

 

Thanks

3 Replies

  • I would create 2 separate reports.

    Then create a new dashboard and add both onto that...or am i missing something?

    • laurent_rio's avatar
      laurent_rio
      Helper I

      This should be interactive , because i will have report contains multiple year of employee resign , so the  axis (year) should be automatically 

      This is sample of my table, where year of resign as x axis will be automatically grouped vs number of resignees and legend is categorized by reason of resign. 


      I know the easy one is create two visual with different time filter but how if i only want to have one time filter - user just only need to select range of time for example if they select 2016&2017 will show 2 pie chart (2016&2017) , if they select 2016-2018 will show 3 chart to compare

      • v-jingzhang's avatar
        v-jingzhang
        Community Support

        Hi laurent_rio 

         

        I don't find such pie chart visual that can meet your requirement. If you are happy with other types of chart (e.g. column chart), you could try Advanced Trellis / Small Multiples visual. With this visual, you can put Year in Categories, Reason in X-Axis and count of reasons in Values. Then you can use a slicer to filter years.

        Regards,
        Community Support Team _ Jing
        If this post helps, please Accept it as the solution to help other members find it.