Forum Discussion
line charts with multiple date columns
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
Community SupportHi, 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.
Hi Allen,
This is exactly what I needed! Many thanks for your advice!
Kind regards,
Tom C