Forum Discussion
Plot 3 date table in one date axis
Hi ,
Quite new with Power Bi, I have 3 table coming from a different reports ( please see table )
I wanted to plot the sum of quantity on the single axis.
my question is how can or do I need to merge the 3 tables to one ?
How to plot it in a single axis. something like below
Release Table
| Release Date | Material | Doc Number | Quantity |
| 15-Feb-22 | 1 | 1 | 10 |
| 02-Mar-22 | 1 | 11 | 10 |
| 15-May-22 | 1 | 111 | 5 |
| 15-Aug-22 | 1 | 121 | 10 |
| 10-Feb-22 | 2 | 2 | 20 |
| 02-Feb-22 | 2 | 22 | 30 |
| 05-May-22 | 2 | 222 | 10 |
| 04-Apr-22 | 2 | 223 | 15 |
| 15-May-22 | 2 | 224 | 10 |
| 01-Aug-22 | 2 | 225 | 5 |
| 10-Jan-22 | 3 | 3 | 1 |
| 05-Feb-22 | 3 | 33 | 3 |
| 03-Apr-22 | 3 | 333 | 5 |
| 01-Jul-22 | 3 | 334 | 5 |
| 30-Sep-22 | 3 | 335 | 5 |
Receive table
| Receive date | Material | Doc Number | Quantity |
| 15-Jan-22 | 1 | 1 | 10 |
| 02-Mar-22 | 1 | 11 | 10 |
| 03-May-22 | 1 | 111 | 5 |
| 04-Aug-22 | 1 | 121 | 10 |
| 10-Jan-22 | 2 | 2 | 20 |
| 02-Feb-22 | 2 | 22 | 30 |
| 05-Apr-22 | 2 | 222 | 10 |
| 04-Apr-22 | 2 | 223 | 15 |
| 09-May-22 | 2 | 224 | 10 |
| 01-Aug-22 | 2 | 225 | 5 |
| 10-Jan-22 | 3 | 3 | 1 |
| 02-Feb-22 | 3 | 33 | 3 |
| 03-Apr-22 | 3 | 333 | 5 |
| 30-Jun-22 | 3 | 334 | 5 |
| 15-Sep-22 | 3 | 335 | 5 |
Plan table
| Plan Date | Material | Quantity |
| 01-Jan-22 | 1 | 10 |
| 02-Apr-22 | 1 | 15 |
| 03-May-22 | 1 | 10 |
| 04-Jul-22 | 1 | 10 |
| 10-Jan-22 | 2 | 20 |
| 02-Mar-22 | 2 | 30 |
| 03-Apr-22 | 2 | 20 |
| 04-May-22 | 2 | 20 |
| 09-Jul-22 | 2 | 10 |
| 01-Jan-22 | 3 | 1 |
| 02-Feb-22 | 3 | 3 |
| 03-May-22 | 3 | 5 |
| 01-Jan-23 | 1 | 10 |
| 01-Jan-23 | 2 | 10 |
| 01-Feb-23 | 3 | 10 |
2 Replies
You don't need to merge the tables. Create a date table, link that to each of the other tables in a one-to-many relationship and then use a column from your date table as the axis for your chart
Hi ronpit76 ,
For this you need to create a calendar table and make ative relationship with the other 3 tables this will result in a model that you can then use for your visualization using the axis the calendar table.
Below two ways of creating your calendar table:
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/
