Solved: Quarter and Year on X axis for forecasting

adambarek · ‎06-24-2020

How can I show quarter and year on the X axis and be able to forecast based on quarter no year. Im currently forecasting only based on year as I can only get the year to show on X axis and forecast as well.

amitchandak · ‎06-25-2020

@adambarek , Use Qtr Start Date

https://docs.microsoft.com/en-us/dax/startofquarter-function-dax

And then use this date on the line then you can forecast

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎06-25-2020

@adambarek , Use Qtr Start Date

https://docs.microsoft.com/en-us/dax/startofquarter-function-dax

And then use this date on the line then you can forecast

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!