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...
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!!

     

     

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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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!!