Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
itskool
Helper II
Helper II

Change of chart title at drill down

Hi everyone,

 

I was wondering if it is at all possible to change the chart title at drill down, something like:

Number of requests per country --> number of requests per city

No need to reflect selected value in the title.

 

I am aware this is the default title that Power BI is creating, but the problem is my chart has field in Tooltips and the default version includes the name of the field in the title too, which I don't want.

 

I have seen someone suggest using bookmarks and buttons, but it seem like too much of a complication, is there maybe an easier way?

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@itskool this can work specifically if you turn on the drill down option (the one highlighted in black) and swith between categories:

SpartaBI_0-1652188357010.png

Now If I click on Audio and it will drill down to its subcateogies:

SpartaBI_1-1652188395710.png


I created this title measure and used it in the conditional formatting option of the title value:

SpartaBI_2-1652188435907.png
This is the pop you get, choose your measure:

SpartaBI_0-1652188607416.png

This will not work if you use the other options:

SpartaBI_1-1652188662098.png

 

 


2022-05-09 22_36_04-Power BI Workspace Datasets License Permissions - Microsoft Power BI Community.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png  SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

thanks - unfortunately what I need is for title to change even without selecting one category...

SpartaBI
Community Champion
Community Champion

@itskool maybe there is some trick without bookmarks after all, let's hope 🙂 waiting for other suggestions from other members and will also think more about it

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.