Forum Discussion
not updating values in tooltip
Hi everyone, hope you're doing good !!
So I created a matrix contains 3 colomns of lab results each result come from a different table . And 3 lignes first is the client , navire then quality . and i have a table that contains min and max of elements each element has a min column and a max column. and the matrix changes values, clients and qualities by changing what element are we inspecting with a slicer.
In my matrix, users can see numerical values (for example, 2.71), but they have no way of knowing whether this value is good or bad without checking another document.
The challenge is that compliance thresholds depend on both the quality (DAP, MAP, Acid, etc.) and the element (MgO, H₂O, etc.).
To solve this, I built a tooltip measure that acts as an instant diagnostic assistant.
Instead of showing a simple label, the tooltip:
- Targets the exact value under the cursor (regardless of the laboratory source)
- Automatically identifies the product associated with the hovered context
- Retrieves the corresponding Min/Max contractual thresholds in real time
- Displays a clear verdict (✅ / ❌) to guide the user
However, I am still facing the following problem:
- In empty cells, the value from the cell below appears, which creates confusion
- If I do not drill down to the level where values exist, the quality name in the tooltip always shows K01-01 (one specific quality), and the threshold interval is empty
- The tooltip shows one value per ligne like others don't exist.
here is the mesure I used :
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.
8 Replies
HI khadijabl2000 ,
I think that you might have a few issues. Tooltips evaluate row context and not cell existence - so when a measrue comes back blank, it still evaluates the tooltips but resuses the nearest valid context. Also, the Selectedvalue will return the single value or the default value - so it is not really wrong as much as it is "confused".
So, the fix is to make the tooltip cell aware and not row aware.
So, you will have to build a cell measure for not isblank and then get Quality from fact data and use that. Then, make your min and max measures and make a column level detection and use that in your measure in tooltips.Thanks for your response. I tried to apply your suggestions, but I think I might have made a mistake somewhere. Could you please provide an example of what you meant?
Thankyou, 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.
Hi khadijabl2000,
Thank you for your update and for confirming that the earlier solution resolved the issues related to the empty cell and context.
Based on our understanding, when hovering over 3.06 shows 3.14, the reason might be that the Valeur Analyse measure is currently aggregating across multiple result tables without being restricted to the active column context. As a result, Power BI may evaluate all three tables together and return the first non-blank value, which often comes from another table or element rather than the hovered one.
One possible approach might be to consolidate the three result tables into a single fact table with a source or element column. This simplification of the model would avoid ambiguity and ensure that the tooltip always reflects the correct hovered value.
We hope this information helps resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
Hi,
I tried this solution and it also didn't work. I transfomed the tree tables into one table the same way in the file you sent but still gaves the same results.
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.
Hi khadijabl2000,
For further analysis, please share either a simplified or sanitized PBIX file. Alternatively, kindly provide the data model diagram in the Relationships view, the matrix configuration including the 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.
