Forum Discussion

gibson1965's avatar
gibson1965
Frequent Visitor
2 years ago

Pie Chart, group small slices

HI, i have:

 

-I have a table "Time sheet" with a lot of Time entry, with "project"  field and "employe" field

-I use pie chart to present employes timesheet per project. 

-i use slicer to filter employe

  Legend = project

  Value = sum(time entry)

I would like to group "small slices" project on "other Project"+

 

Thanks!

 

Need Help
Tutorial Requests

6 Replies

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    2 years ago

    Hi gibson1965 ,
    If these small slices are for same project everytime, you can simply group them and take this grouped field into Legend.
    If it varies everytime according to slicers or data, then you can create a calculated column with if case on % to total and pull it into legend.

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
    • gibson1965's avatar
      gibson1965
      Frequent Visitor
      2 years ago

      unfortunately, the small slices are always different depending on the employee

      • Anand24's avatar
        Anand24
        Icon for Super User rankSuper User
        2 years ago

        gibson1965 ,
        Can you provide a sample data in table and tell us the % in pie chart below which you would consider it as small slice?

         

        Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

        Proud To Be a Super User !!!
        LinkedIn