Forum Discussion

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
9 years ago

Create Pie chart with group by

Hi all,   I have a dataset like this:   emp nr  year_month uniquenumber 161860 201702         25005 161860 201702         25006  161860 201703         25007  365630 201702         25008  365...
Need Help
MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
9 years ago

I've spent a few hours this weekend but it's really hard.... Anyone with more DAX skills than me?

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi MiKeZZa,

Could you please share your .pbix for further analysis?

Best Regards,
Angelia

  • MiKeZZa's avatar
    MiKeZZa
    Icon for Post Patron rankPost Patron
    9 years ago

    Here is the (anonymised) pbix file: Download

     

    It's (in my opinion) all about the fields used in the Pie Chart.

     

    The filtered person has 2 incidents so I expect a pie with value 2 filled for 100%.

  • MiKeZZa's avatar
    MiKeZZa
    Icon for Post Patron rankPost Patron
    9 years ago

    Anyone an idea?