Forum Discussion

zoubaier's avatar
zoubaier
Icon for Helper I rankHelper I
6 years ago

Quarters 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 t...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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.

zoubaier's avatar
zoubaier
Icon for Helper I rankHelper I
6 years ago

Hey amitchandak ,

 

I have tried this but this is not allowing me to have the time intelligence and plot the trendline.

 

Best Regards