Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

incorrect values in visuals

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. 

 

Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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