Forum Discussion
not updating values in tooltip
Hi khadijabl2000,
Based on our understanding, the issue may be caused by the current data model structure or by filter context propagation, rather than by the DAX logic.
For further analysis, could you please share either a simplified or sanitized PBIX file. Alternatively, please provide the data model diagram in the Relationships view, the matrix configuration with rows, columns and values, the Valeur Analyse measure, along with a small sample dataset for all tables and the expected output after hiding all sensitive information.
Thank you.
Community SupportThankyou, collinq for your response.
Hi khadijabl2000,
We appreciate your question on the Microsoft Fabric Community Forum.
Based on our understanding, we have implemented a unified value measure using COALESCE to correctly capture values across different sources. We replaced SELECTEDVALUE with HASONEVALUE to ensure a single Quality and Element context. We also added a Has Data check to prevent tooltips from appearing on empty cells. Furthermore, we calculated the minimum and maximum thresholds using CALCULATE with the appropriate filter context based on both Quality and Element. This ensures that the tooltip is rendered only when a valid single context exists.
As a result, the tooltip is fully cell aware, eliminates incorrect values appearing in empty cells, prevents defaulting to incorrect qualities such as K01-01, and ensures accurate evaluation of CONFORME or ALERTE.
Also, please find attached the screenshots and a sample PBIX file, which may assist in resolving the issue:
We hope the information provided helps to resolve the matter. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
Hi,
thank you for your response.
I tried this solution. And the problem off the empty cell is solved thanks to you also does not get blocked in k01-1 .However when I try to display the value "valeur analyse" it always takes the value of the last colomn. but when I tried it in the file that you send it worked normally. In my case each column of value comes from a table of results and there is 3 tables . for exemple when a hover over 3,06 of the quality k09-02 it shows 3,14 and not 3,06. I don't know from where comes the problem.