Line Chart Tooltip - X Axis Label

[b_phippy]

Hello,

I have a line chart that shows averages for 2 groups, the X-axis has three levels: Month, Week, and Date. (Figure 1)  When you drill down to the next levels of the hierarchy, the tooltip doesn't show the X-axis label.  This gets a bit confusing when looking at the week and date displays (Figure 2).  I'd like to add the X-axis label to the tooltip (similar to the column chart tooltip) so it changes based on the level you are viewing (Figure 3). I've tried creating a custom tooltip, but it shows all three levels at all times (Month, Week, Date).  Is there any way to add the X-axis label to the tooltip?

Figure 1:

Figure 2:

Figure 3:

[Anonymous · Accepted solution]

Hi @b_phippy,

You can try to create a custom report tooltip page with visuals and use it as a tooltip on your chart. 

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

To show the different data levels, you can add a formula with if statements and filters to check the current row context level.

Clever Hierarchy Handling in DAX - SQLBI

Row Context and Filter Context in DAX - SQLBI

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin Sheng,

You suggested for creating a custom tooltip, but what if the requirement is only for "enabling an option to show X-axis label name on tooltip." Can you suggest how do we achive this instead of creating a custom tooltip which would be a complete different method.

Regards,

Haveesh