web
You’re offline. This is a read only version of the page.
close
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