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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.