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

     

     

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