Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
83 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
129 | |
108 | |
63 | |
55 |