Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I must have misunderstood the new release of Power BI Desktop.
I thought they added support for hierarchies and drill down inside a hierarchy?
So I have a line chart with fiscal years and periods (period child of year in hierarchy) and then I'm charting TotalSales.
It shows up great for that, but if I want to drill down from year to period (month basically) and that comes from a time table/date marked table in SSAS Tabular...I can't drill down?
Is there not support for drill down?
Hi @OneWithQuestion,
Based on my test in the newest Power BI Desktop ( Version: 2.35.4399.601 ), drill down is not available in the general Line chart. For this issue, I will report it internally, and keep you updated once I get any feedback.
In your scenario, if you want to use Drill Down feature for a line chart, you can add a Line or Stacked chart, or Line or Clustered chart, then place corresponding fields in Shared Axis and Line Values properties to workaround the issue. See:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Drill down is supported for lots of visuals, but currently not for Line Charts.
Proud to be a Super User!
@Sean I tried being OneWithSnideRemark for a week but I didn't get nearly as many kudos for it.
Proud to be a Super User!
Yes it is indeed very tempting sometimes
Yeah. But not in this thread, to be fair to @OneWithQuestion. Other than the easy name joke, it was a perfectly cromulent question.
Proud to be a Super User!
Thank you, I feel that your reply embiggens the overall utility of the conversation and further reinforces its cromulence 🙂
Hi @OneWithQuestion,
I have gotten the feedback from the Microsoft. Currently the drill down feature is only available for some of the visualizations. Here's the list:
They said that the drill down feature is not supported in line charts, this is by design.
Thanks for your understanding and support.
Best Regards,
Qiuyun Yu
Yes I had to test it to see for myself and sure enough not yet supported!
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |