Quarter names disappear when I drill down

[reymard]

Hi Community,

I don't understand why the names of the quarter are not displayed when I drill down from a yearly view to a quarterly one.

The name of the first month of the quarter is displayed on the x-axis. But the tooltip indicate well the name of the quarter.

Does anyone can assist on that ?

Thanks a lot.

[v-yuta-msft]

Hi reymard,

Please click “Go to the next level in the hierarchy” on the right hand of “Drill up”.

If you want to have year, quarter and month in x-axis, a column chart is recommended.

Regards,

Jimmy Tao

[reymard]

Hi @v-yuta-msft

Thank you for your answer.

It works if I use the “Go to the next level in the hierarchy” drill down button. But I'd like to drill down using the "Expand all down one level in the hierarchy" to get the aggregate per Year-Quarter and Year-Quarter-Month.

When I use this button, I get this correct aggregate but the labels on the X-axis are the first month of each quarter + year, instead of name of the quarter + year. So I get "Jan 2017" on the X-axis displayin the value for Q1 2017, "Apr 2017" for Q2 2017, etc.  

Do you know how to get the correct labels ?

Thank you for your help.