Forum Discussion
Helper IQuarters not shown in the X Axis when using line chart
Hello,
We are not able to show the quarters from the date hierarchy in the line chart.
This issue is easy to reproduce using datetable and line chart. Using Datetable is fundamental to be able to show the trendline.
Do we have a solution for this or we should wait for an update?
Regards
3 Replies
- amitchandak
Super User
zoubaier , I think it showing the month -year of the Qtr.
You can create a qtr as per need in Date table and use that
Qtr No = FORMAT([Date],"Q")
Qtr = FORMAT([Date],"YYYY") & "-Q" & FORMAT([Date],"Q")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 :radacad sqlbi My Video Series Appreciate your Kudos.
zoubaierHey amitchandak ,
I have tried this but this is not allowing me to have the time intelligence and plot the trendline.
Best Regards
v-kelly-msftCommunity Support
Hi zoubaier ,
Check the similar thread below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
