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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
klehar
Helper V
Helper V

Bring/Combine 2 dates on the same column

Hi,

 

I have a sample data that looks like this:

 

Opportunity IDHW DateHardware Order($M)SW DateSoftware Order($M)
OPE1231/1/2021451/1/202170
OPE1241/8/2021301/10/202113
OPE1251/8/2021961/10/202123
OPE1261/8/2021331/11/202139
OPE1271/8/2021461/11/202170
OPE1281/6/2021981/11/202158
OPE1291/9/2021681/12/202136
OPE1301/9/2021221/12/2021100
OPE1311/9/2021631/13/2021100
OPE1321/9/2021411/13/202168
OPE1331/11/2021421/13/202144
OPE1341/12/2021421/13/202167
OPE1351/13/2021621/13/202188
OPE1361/14/2021551/14/202197
OPE1371/15/2021371/15/202118
OPE1381/16/2021241/16/202180
OPE1391/17/2021171/17/202151
     

 

Using this data I want to visualize data that looks something like this:

klehar_0-1631173788251.png

 

HW and SW should be on the same axis with drill down till week level.

But the issue is the dates are not on the same axis, meaning, there are different columns for hardware and software

Some dates are missing in HW and some are missing in SW. 

How can i bring them on a common date axis and then use that to visualize my data?

 

 

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@klehar 

Some transformations are required in power query, please download my sample pbix and check applied step in query editor.

hs and ws.PNG

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@klehar 

Some transformations are required in power query, please download my sample pbix and check applied step in query editor.

hs and ws.PNG

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

AntoineTRICHET
Resolver III
Resolver III

Hi @klehar 

You can maybe go back to Power Query, duplicate your table : you will have two same tables. In the fisrt one you only keep SW information, rename the columns Software Order($M) as Order Value($M) and SW Date as Date, and you add a column named OrderType (each value = "SW"). In the other one you do the same thing but for HW. Finally you append the wo queries.
You will have then only to apply the changes and use the new table : put OrderType in Legend, Order Value($M) in Value and Date in X axis.

Please accept it as a solution if it solved your issue

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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