Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data importing from Excel

Hello,

 

Its first time I'm seeing it. But my line chart is being dissrupted only, because I have same data multiple data rows with same id/ number combined into one in generated chart. Now my SPC chart is broken. With Upper limit tolerance normally  +1, suddenly i got +2, +21 cause of combining.

 

Is there any good solution without using dax?

 

Ok, dismarked option for the summing of entries, which was turned on. Case closed

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,
    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    xx data entries were summed up as one only because they had same date/ measurement result. I dont know why but but at line chart theese entries were summed up and from +-1 tolerance, it was suffed up to +-21. The strange thing that power bi automatily changed it only for that.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, Anonymous ;

    It's really hard to understand your logic, can you provide more samples?

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.
    4. Relation between your tables.

     

    Best Regards,
    Community Support Team_ Yalan Wu

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      The values were summed at chart from the table for particular dates(it was selected a "number"), changing type of values helped. Now table has got normal values the same as is in original excel file. There is no relationship in the file.

       

      Thank you for the interest!

      • v-yalanwu-msft's avatar
        v-yalanwu-msft
        Community Support
        4 years ago

        Hi, Anonymous ;

         

        Is your problem solved?? If so, Would you mind accept your repliy as solution? Then we could close the thread. Thank you.

        Best Regards,
        Community Support Team_ Yalan Wu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.