Forum Discussion

omi18's avatar
omi18
Frequent Visitor
7 years ago
Solved

Visualization Summing the Values

Hello Guys,   I am importing the data from SQL Server and trying to plot a bar graph. While doing this power bi is showing me different number than the number is present in Data section.   Screen...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi omi18

     

    Power BI is a aggregation tool.The way around this would be to create an index column in query editor to provide the uniqueness of rows.Then use the index column for legend. For example:

     

    Regards,

    Cherie

     

     

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi omi18

 

Please check below picture and let me know if it is your case.

Regards,

Cherie

  • omi18's avatar
    omi18
    Frequent Visitor
    7 years ago

    Hello v-cherch-msft

     

    Yes, But Instead of Question ID, I want to use University ID. So visualization will present Universities by Enrolment.

     

    Thanks,

    Omi

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi omi18

       

      Power BI is a aggregation tool.The way around this would be to create an index column in query editor to provide the uniqueness of rows.Then use the index column for legend. For example:

       

      Regards,

      Cherie