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