Forum Discussion

Dave2534's avatar
Dave2534
Regular Visitor
4 years ago
Solved

Grouping Values in Pie Chart

Hello,    I have a pie chart that has a legend of employee names and counts the amount of shifts they have had in the last 14 days.    I am looking to count and group the results into three categ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Dave2534 ,

    I created some data:

    Here are the steps you can follow：

    1. Create calculated column.

    Switch =
SWITCH(
    TRUE(),
    'Table'[Count]>=0&&'Table'[Count]<=9,"Group1",
    'Table'[Count]>=10&&'Table'[Count]<=12,"Group2",
    'Table'[Count]>=13,"Group3")

    2. Set the color for the [Switch] column.

    3. Result:

    If you need pbix, please click here.

    Grouping Values in Pie Chart.pbix

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
4 years ago

Hello Dave2534

 

So you need to catch the last 14 days and count the number of shifts? 

Creat a calculated column in the employee table where you will pick the last 14 days with the function dateadd (https://docs.microsoft.com/en-us/dax/dateadd-function-dax) .

if you have dificulty send a pbix example and i will try to help. 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC