Skip to main content

Power BI

New

Different Titles for Different Levels Of Drill Down

Vote (71) Share
Jake Carville's profile image

Jake Carville on 17 Feb 2016 01:41:10

I think it would be really powerful and insightful if you were able to add different titles to different levels of a chart as you drill down through it.

Comments (5)
Jake Carville's profile image Profile Picture

78b99b56 b449-4f51-9788-69096ee53ade on 05 Jul 2020 22:59:14

RE: Different Titles for Different Levels Of Drill Down

'I agree with Kyle's comment

Example: When I drill through a date hierarchy and I get down to the day, the default title reads "Sales by Day and Region" and the bar graph labels are 1, 2, 3, 4... - but what month is that? And what year?

There is no indication of the higher levels in the hierarchy from whence I came?

Possible solutions:
- Breadcrumbs in the graph title
- A way to build dynamic graph titles using tokens that represent the drill hierarchy
- Have the graph labels retain the drill hierarchy. Instead of the labels drilling as "2016" --> "June" --> "1" they drill as "2016" --> "June, 2016" --> "June 1, 2016"
- Stack up the axis titles as we drill (first line is current level, 2nd line is the level above that, etc.) so my title would be:
Day
June
2016
and now the bar graph labels (1, 2, 3, ...) make sense

This is exactly what I would need the drill down to do in order for other people to follow what the data is actually reporting on.

Jake Carville's profile image Profile Picture

d32b757a 4d29-4711-b09b-c018faebba44 on 05 Jul 2020 22:30:02

RE: Different Titles for Different Levels Of Drill Down

Definitely needed. Without it I have no idea about the current drill down context.

Jake Carville's profile image Profile Picture

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 22:28:49

RE: Different Titles for Different Levels Of Drill Down

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).

Jake Carville's profile image Profile Picture

32da886b abf9-4030-9dd7-58d3ae387431 on 05 Jul 2020 22:25:26

RE: Different Titles for Different Levels Of Drill Down

'Yes - I agree. I'm not sure if this is exactly what Jake is thinking but I need a way to see where I drilled FROM.

Example: When I drill through a date hierarchy and I get down to the day, the default title reads "Sales by Day and Region" and the bar graph labels are 1, 2, 3, 4... - but what month is that? And what year?

There is no indication of the higher levels in the hierarchy from whence I came?

Possible solutions:
- Breadcrumbs in the graph title
- A way to build dynamic graph titles using tokens that represent the drill hierarchy
- Have the graph labels retain the drill hierarchy. Instead of the labels drilling as "2016" --> "June" --> "1" they drill as "2016" --> "June, 2016" --> "June 1, 2016"
- Stack up the axis titles as we drill (first line is current level, 2nd line is the level above that, etc.) so my title would be:
Day
June
2016
and now the bar graph labels (1, 2, 3, ...) make sense

Something ...

Jake Carville's profile image Profile Picture

e30edd0a 2fdb-4daf-a900-7a86fea2c51c on 05 Jul 2020 22:21:35

RE: Different Titles for Different Levels Of Drill Down

Yes Jake! That's a feature that would be very useful. Good thinking