Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |