Matrix visual tooltip issue

[Manikanta2108]

the above picture matrix visual automatically generated - its not in a good format. how can i fix this isssue?

[v-tejrama]

Hi @Manikanta2108 ,

Thanks for sharing this question with the community. From what you’ve described, the behavior you’re seeing in the matrix is actually expected. At the sub-product level, values will only show up if there is data present for that specific item, which is why something like AppLens-FooterAPI is displaying a value of 1 while the other AppLens components and GeoMapping remain at 0. The total at the product family level is still calculated correctly since it aggregates across all of the sub-products. If your goal is to display values inherited down to both the family and sub-product levels, you may need to make some adjustments to your data model or tweak the measure logic. Approaches like using CALCULATE in combination with ALL or FILTER can help you bring the broader family context into the calculation, rather than only looking at the sub-product in isolation. Otherwise, the matrix is behaving as designed, reflecting the hierarchy based on the data it receives.

Best Regards,

Tejaswi.

Community Support

[v-tejrama]

Hi  @Manikanta2108 ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you,

Tejaswi.

[v-tejrama]

Hi  @Manikanta2108 ,

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

Thank you.

[v-tejrama · Accepted solution]

Hi  @Manikanta2108 ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you,

Tejaswi.

[lbendlin]

Use a custom tooltip page

NOTE: This will only work for the Values area.

[jgeddes]

This article from Microsoft Learn outlines how to create custom tooltips.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips