cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Danielnir
Frequent Visitor

Tooltip Title Based on Drill Down Level

Hi All,

 

I have a bar chart with a drill-down option. 

The levels (collumns) are:

1. Category (Sales, Expences, Overheads)

2. Subcategory (Indirect Labour, Equipment Hire etc).

 

I made a tooltip that is showing data from other months. 

The problem is that I can only select one column as a header in "Card" Visualisation. When I'm drilling down from "Category" to "Subcategory", I still have value from a column "Category".

 

How to make the title in this Tooltip to change along with the drill-down level on the main chart?

Hope it makes sense 🙂

 

Thanks in advance!

4 REPLIES 4
Pragati11
Super User
Super User

Hi @Danielnir ,

 

I am not able to understand your query properly. Please add details like screenshots: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Hi Pragati11,

 

Thanks for the quick reply. Here goes some more detail:

 

I have a bar chart with a tooltip attached. On the tooltip, I have another bar chart with historic data and a Card visual with category name.

It looks like that:

Danielnir_0-1627914337735.png

When I'm drilling the main chart down, the category name on the tooltip stays the same.

Example: When I'm drilling Overheads in the main chart, the category name on the tooltip remains the same:

 

Danielnir_1-1627914568757.png

I would like to make a title from the tooltip to change along with the drill-down level on the main chart.

 

Hope it clarifies my question 🙂

Hi @Danielnir ,

 

What happens if you add same drill-down fields to your tooltip chart?

I haven't come across anything like this before and sure if this is possible to do in custom tooltips.

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




The chart in Tooltip is showing correct data. It's only the category that is displayed in Card visual that I want to drill down when drilling down the main chart. 

 

Maybe I should mention that Main Category and Subcategory are separate columns. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!