Forum Discussion
ronpit76
4 years agoNew Member
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 ...
MFelix
Super User
4 years agoHi 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/