Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
nbmalla
Frequent Visitor

Pivoting and merging

Hi everyone.

Hope you all are doing great.

I got two pieces of data to visualize. One for sales and one for transactions. Records are weekly and placed in different sheets.

Transaction2022,Transaction2023 and Sales2022,sales2023.

I unpivoted the tables separately and merged them as Sales and Transaction.

I loaded them in Powerbi but when I tried to visualize the result it was repeated numbers.
I might be wrong during pivoting or merging or even connection with other tables.

Is anybody kind to support me?

https://xgf.nu/K21XS

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

First step is to bring your data into a usable shape.  You list 2022 and 2023 data but your calendar ony covers 2023 - I would rethink that.

 

Next step is to adjust your data model

 

lbendlin_0-1701652299382.png

 

With that you can now create your visuals according to your needs.

lbendlin_1-1701652444278.png

 

View solution in original post

2 REPLIES 2
nbmalla
Frequent Visitor

Thank you do much for your support.

lbendlin
Super User
Super User

First step is to bring your data into a usable shape.  You list 2022 and 2023 data but your calendar ony covers 2023 - I would rethink that.

 

Next step is to adjust your data model

 

lbendlin_0-1701652299382.png

 

With that you can now create your visuals according to your needs.

lbendlin_1-1701652444278.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.