Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Pivoting replaces values with null.

Pivoting replaces values with null.
I have an unpivoted table that is imported from the database and when I pivot the table, with pivoting is done okay in the structure but some values are replaced with nulls.

 

Any ideas as to why this might happen?

Need Help
Tips and Tricks

2 Replies

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

    Anonymous not sure why you are pivoting it, usually for Power BI, unpivot is the right data for reporting.

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.⚡

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  Anonymous ,

     

    Could you pls attach some screenshots about your issue?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!