Forum Discussion
not updating values in tooltip
- 4 months ago
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 ,
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?