Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

unpivot data new lignes

Hello,

Here is a case that I do not understand, I have rows that are created with "_5" at the end of the row but this does not correspond to anything.

I find this abnormal, while I have no problem for the other columns whose rendering is consistent

 

Any explaination ?

 

After filtre on "froid"

I get 2 lignes :

video :

Thanks

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    Anonymous interesting, hard to tell what is going on there. Can you share pbix file, and remove sensitive information before sharing, and also make sure the data source file since will be required to look at the PQ.

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Ok when i clean data, i found it, i have 2 lignes with the same value

      Strange i didn't fint it the first time when i use the search fonction.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    Anonymous I hope the issue is resolved now. That's what I was going to check.

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.