Forum Discussion
line charts with multiple date columns
Hi all,
i am struggling with making a line chart with multiple date columns.
Within our database we have a column for al the people that started within a specific month and a column for all the people that stop in a specific month.
The issue I am facing is that there can be months that we don’t have any starter or stoppers. This means that I cannot use these columns as an axis because I would lose data from the other column. I’ve tried creating a new calendar table and create a relationship but I am doing something wrong because I cannot seem to get a correct visual.
Many thanks in advance!
Please refer my blog
Make sure you have date calendar
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functionsAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
3 Replies
- amitchandak
Super User
Please refer my blog
Make sure you have date calendar
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functionsAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 
v-alq-msftCommunity Support
Hi, Anonymous
Based on your description, you may create a calendar table with 'CALENDARAUTO' function. It is important to have a continuous data table to use time intelligence functions. Then you may build relationships with the fact tables. You may also try POWER KPI visual. For further information, you may refer to the following link.
https://community.powerbi.com/t5/Desktop/Line-Chart-Multiple-Columns/m-p/284682
If I misunderstand your thought, please show me your sample data and expected result. Do mask sensitive data before uploading. I am glad to solve the problem for you. Thanks.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.