create a dynamic title which works with drill down/up

[gilr1975]

Is there any option to create a dynamic title that works with drill down/up ?

For example, I have a column chart for sales in region and I would like a title to be changed if I drill down to sales in departments.

[amitchandak]

@gilr1975 , refer if can help

https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
https://medium.com/@patilpoojaif/dynamic-title-in-power-bi-164903723c68
https://community.powerbi.com/t5/Desktop/Dynamic-title/td-p/378426

[gilr1975]

it is good for a dynamic title when you use filter/slicer, but it doesn't work when I try "go to the next level in hierarchy".

The title doesn't change. 

I need to customize the title text.

[v-deddai1-msft · Accepted solution]

Hi @gilr1975 ,

At the beginning, I wanted to write measure to fulfill your requirement, but due to drill down does not change filter context, so this approach is not going to work.

If you've never modified the default title: XX by XX, the title will automatically change when you drill down. Once you custom the title, it becomes static.

As far as I can think of, I suggest you use a combination of Button and Bookmark to change the title. I also suggest you create an idea for it in Power BI forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai