Default tooltip page --value shows for unavailable category.

[JothiG]

This is my tooltip(default). for year 2024 , i have value only for 11 category but it shows value for 13 category. how to solve this problem.

[Nabha-Ahmed]

Hi @JothiG 

In Power BI, when you use a field from a table with a relationship, it often auto-fills missing categories with blank values.

Tooltip visuals inherit the axis / legend context, so they can show all possible categories instead of only the ones with data.

---

Solutions

1️⃣ Filter out blank / zero values in the tooltip

In Power Query or in your measure, ensure categories without data return BLANK() instead of 0.

Example:

MeasureWithData =
IF(
SUM('Table'[Value]) = 0,
BLANK(),
SUM('Table'[Value])
)

Use this measure in the tooltip. Power BI will only show categories with data.

---

2️⃣ Use “Show items with no data” carefully

Check your visual settings:

1. Select the visual that triggers the tooltip.

2. Go to Format → Data/Category.

3. Turn off “Show items with no data” for your category field.

This prevents categories with no values from appearing.

---

3️⃣ Filter categories in the tooltip visual itself

If your tooltip is a report page tooltip, add a filter to the tooltip page:

Category → is not blank

Or apply a visual-level filter for your measure > 0.

If this solution helped you, please mark it [as theSolution]answer so it can help others as well

Best

[MasonMA]

Hi, 

Are the values on the tooltip from a DAX measure? also could you share .pbix file with only this chart and related data so that others can take a look? 

[rohit1991]

Hii @JothiG 

The default tooltip shows all categories in the data model, even if the selected year has no values for some of them. To show only the categories that actually have data for 2024, you need to use a custom tooltip page and turn on “Keep all filters.” Then add the same visual or table to the tooltip page this forces the tooltip to respect the Year and Category filter context, so only the 11 categories with real values will appear instead of all 13.

[JothiG]

custom tooltip also shows same result.