I have a matrix table with expense categories showing the total amount for the selected period. Then I created a tooltip showing the evolution of each expense category from 2021 to 2023. The tooltip, applied to the matrix table, is working fine, just as I wanted. When I filter another visual showing product categories, the matrix table values are updated accordingly, but not the tooltip. It still shows the total amount for the selected (hovering) category and not the expense category amount for the selected product category. I have read that the problem could be the fact that I don’t have the product category filter on my matrix table. Even if I add this filter to my tooltip page, it doesn’t work. Is there any workaround to fix that?
When i ask EDNA AI within the Enterprise DNA. Here some of things you should check.
To ensure that your tooltip reflects the filtered product category, you can follow these steps:
Update Tooltip Interaction:
Check the tooltip interaction setting in Power BI for the matrix table. Make sure the tooltip is set to "On" for "Selected" data points. This ensures that the tooltip reflects the selected data point in the matrix table.
Filter on Tooltip Page:
Include the product category filter on the tooltip page as well. This will ensure that the tooltip values adjust based on the product category selected in the other visual.
Sync Slicers:
If you have multiple pages or visuals, make sure to sync slicers across the pages. This will ensure that when you filter one visual by product category, it also filters the tooltip page accordingly.
Check Tooltip DAX:
Review the DAX measure used in the tooltip to calculate the expense category amount. Ensure the measure considers the product category filter context to show the correct values in the tooltip.
Test Interactions:
Test the interactions between the visuals and tooltips by selecting different product categories and verifying if the tooltip updates accurately based on the selection.
By following these steps, you should be able to sync the tooltip with the selected product category in your matrix table visualization.
DataMentor and EDNA AI within the EDNA platform will be able help you in your issue.
Thank you very much for your reply to my message. I would like to apologize for my delayed response.
I’ve created an example to explain the issue I am facing. You can find the PBIX file attached.
In the file, I have a matrix table and a bar chart. In my matrix table, there is a tooltip showing the year-over-year evolution of each cost type. The matrix is being filtered by year (slicer). My problem is that when I select a category in the bar chart, the tooltip in the matrix table does not update accordingly. Is there any solution to this issue?
Note, though, if you do that your date slicer will affect your tooltip page and so only the year you have selected in the year slicer will appear in the tooltip. and since you have year on your x-axis in the tooltip page, only that year will show so it will be a dot instead of a line (and that dot will be redundant with the value you are hovering over).
I have year = 2022, and category = “Cat. 1”. if i hover over Value for Cost Type = “Energy”, the tooltip will display just that one value for energy in 2022 for Cat. 1.
In my case, I want to ‘Keep all filters’ but, at the same time, show all years and not just the year selected in the slicer. Someone kindly suggested activate the “Keep all filters” option and create a dummy year table (‘disconnected table’) to use in the slicer. It makes sense and actually works, although I feel some difficulty adapting some formulas in my dashboard and I think the overall performance decreased.
