Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Line chart X axis only shows year

Hello,   I am using a Date column for the X axis on a line chart. It only shows the year and I cannot drill down to quarter, month or day.   Could you help me figure out what am I missing?   T...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Anonymous

     

    Currently, it's not supported to put entire hierarchy into a line chart axis so that we can't drill down in line chart as Nhallquist mentioned. It can't resolve a continuous line when drilling down to different level data. So to use drill down, I suggest you use column chart. 

     

    Regards,

Nhallquist's avatar
Nhallquist
Helper V
10 years ago

I fought this for a while too.  Make sure you don't have the Date Hierarcy checked in the chart settings.  Wherever your Date field is in the Visualization settings, drop-down the little arrow and make sure Date has a green check, and not the Date Heirarchy.

 

 

This is what usually happens to me, so try there first.