Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

sales analysis

Hello I have a following Power BI query to solve.   Tasks: 1. Data Import and Transformation: o Import the data into Power BI. o Create a relationship between the Region and Product tables....
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    I don't think it's necessary if there's no clear need for it. Pivoting affects the creation of visuals.

    You just need to make sure the data is arranged in this way.

     

    Best Regards,
    Wenbin Zhou

  • Anonymous's avatar
    Anonymous
    2 years ago

    Ok that great. I got it now. Thanks Wenbin!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi

Thanks for your reply.

Regarding unpivot and pivot I know how to do it. But I don't understand what to pivot .

 

Also I don't understand the reason behind doing unpivot and pivot in this data. Is it necessary here ?Could you please explain?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

As I understand it, pivot just lets you look at the data from another angle.

If you perform a pivot operation in Power query, it is not conducive to building visuals in Power BI Desktop, so perform an unpivot operation.

You don't seem to have performed a pivot operation in your step, and a unpivot operation seems to be unnecessary.

 

Best Regards,
Wenbin Zhou