Skip to main content
Microsoft Idea

Power BI

Needs Votes

Different visualizations for drill down charts

Vote (79) Share
Jessika Sutton's profile image

Jessika Sutton on 27 Mar 2015 03:18:15

For multi-level drill down visualizations, it would be nice to be able to have different visualization types for each level. For example, the bottom detail level of my report should actually be a table format since it has the lowest level of detail.

Comments (9)
Jessika Sutton's profile image Profile Picture

Mike Power BI User on 05 Jul 2020 23:54:19

RE: Different visualizations for drill down charts

Agreed. If I have a line chart with calendar period as the top level of the hierarchy, when I drill into a certain month often times the next level of the hierarchy - for example, "region" - does not make sense to also show as a line chart (bar chart would be more appropriate for categorical items). Right now, my only option is to change from a line to a bar chart, which makes the top level of calendar period less readable (trends over time should be shown as lines).

Jessika Sutton's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:10

RE: Different visualizations for drill down charts

Yes pls!

Jessika Sutton's profile image Profile Picture

Power BI User on 05 Jul 2020 22:47:10

RE: Different visualizations for drill down charts

Would be even better if you could set a default sort along with the new visualization.

Jessika Sutton's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:07

RE: Different visualizations for drill down charts

I do a lot of HR dashboarding and this could really clean up my reports by making it so that when you click on the the department in a pie chart it drills down to a break down of a similar dimension, but represented in a table or a bar chart. The See data option when you right click is helpful but not intuitive or user friendly, as you have to see a messy pie chart before what you were actually hoping to see.

Jessika Sutton's profile image Profile Picture

Mike on 05 Jul 2020 22:28:50

RE: Different visualizations for drill down charts

Agreed, would have submitted this idea myself if it wasnt already here. Too bad for the low vote count + I dont have any votes left :(

Jessika Sutton's profile image Profile Picture

Todd Waterman on 05 Jul 2020 22:26:59

RE: Different visualizations for drill down charts

MS please make this happen!!!!!

Jessika Sutton's profile image Profile Picture

Rohit Bundele on 05 Jul 2020 22:25:10

RE: Different visualizations for drill down charts

It would be great if the type of chart changes as we drill down,
Such that the drilled down chart should use a different metric already placed

Jessika Sutton's profile image Profile Picture

Christopher Woodward on 05 Jul 2020 22:13:58

RE: Different visualizations for drill down charts

I couldn't agree more on the table format thing. Though a drillable table would be nice.

Jessika Sutton's profile image Profile Picture

Daniel S Sutton on 05 Jul 2020 22:12:54

RE: Different visualizations for drill down charts

Would be good to be able to add different dimensions to the drill down.