line charts with multiple date columns

[Anonymous]

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!

[v-alq-msft]

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.

[Anonymous]

Hi Allen,

This is exactly what I needed! Many thanks for your advice!

Kind regards,

Tom C

[amitchandak · Accepted solution]

Please refer my blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

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-functions

Appreciate 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-wi...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601