Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerBI Aggregates Inaccurate Data

Hello,

 

I have the data I want to use that includes the percenatges for department scores for each department. I want to use those exact numbers in PowerBI, but instead it sums all the percentages and now it is inaccurate. I took off "Do not summarize" I still can't select it to show me only the numbers I already have. Makes sense? I hope I explained this well.

 

 

 

 

 

 
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Choose the visual, then change the visual to table directly in the Visualizations Pane.

     

    After that, set all the values don't summarize.

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Oh yes. I did that and when I switched it back to the line chart it just turned into count. But when I selected min that seemed to work and get me the correct numbers.

     

    Thank you for your help!!

     

     

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous first not sure why you are using matrix visual, use table visual and then select don't aggregate.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      I had no idea I was using a different visual. How do I change this? I do not see those options.

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Choose the visual, then change the visual to table directly in the Visualizations Pane.

         

        After that, set all the values don't summarize.