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

     

     

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