Forum Discussion

Maureen's avatar
Maureen
Helper III
7 years ago

x-axis drill down on line graph

I have a date hierarch as the x-axis on a line graph.  If I drill down from year, I can see the month name.  However, when I drill down with the "Expand All" option, I only see the year on the x-axis with the monthly data plotted.  How can I see year and month on the x-axis with the drill down feature.

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Maureen 

    Do you mean that when you Expand All, the line chart shows as Fig.1? If so, you can make the chart wide enough.

     

    Or, you can change the Type of X axis to Categorical to display all date values in x-axis.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.