Forum Discussion

darynv_za's avatar
darynv_za
Advocate I
9 years ago

Pie Chart %

I have looked at some other solutions, yet mine does nto seem to fit into any categories or solutions. I have a field containing document numbers(so there are no blanks), and then a status, if I do a quick Calc on the Dictinct Count I get 94.44 in the label for one status and 5.68 for the other (100.12 % total), yet when I mouse over the 94.44 status it shows 94.32%. I have no filters, this is just data from a SQL view.  I am at a loss here an obviously you can't produce anything for a customer that shows more than 100% otherwise they begin to question the data.

Need Help

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    darynv_za

     

    I have tested it on my side and I was not able to reproduce this issue. Could you post some sample data which can reproduce this issue in your case? It's better to upload a pbix file.

     

    Regards

    • darynv_za's avatar
      darynv_za
      Advocate I
      9 years ago

      How do I upload the pbix? It is 300 Meg though

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        darynv_za

         

        You can upload it to OneDrive or DropBox and send me the link in private message. Do mask sensitive data before uploading.:smileyhappy:

         

        Regards