incorrect values in visuals

[Anonymous]

Hi,

I have 6 motnhs of huge data in my excel sheet containing around 6k Data entries with different quality score of each entry. 

While creating visuals graphs are showing incorrect values as well as representation. 

Please suggest me which visual/filter should i use for correct data visualization. 

[v-lili6-msft]

hi, @Anonymous

It seems that there is something wrong with your relationship in the data model.

Please check the relationship of different table and if Cross filter direction should be Both?

If it is not your case, please share sample pbix file and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[Anonymous]

HI @Anonymous,

Could you provide us with more information. 

For example, are you combining data from multiple tables? This looks like a link error between tables. 

Greetings,

Ronald

[Anonymous]

Hi @Anonymous ,

Thank you for prompt response but would like to tell you that there is only one table in excel sheet.

Some how i have sorted out that problem but still if i wanted to take weighted average of quality score as per countries still i am struggling.