Forum Discussion
Tooltip showing same values across different measures in Matrix visual
hi Aarush9885
You will need to use a disconnected table that returns the desired calculation depending on the current row value. Dynamic format string is also needed if the measures have different formatting (%, $, or whole number only).
Please see the attached pbix.
Hey Khashayar
I tried implementing the field parameters approach you suggested. Unfortunately, I’m still getting the same values repeated across all columns in the matrix.
Thanks a lot for pointing me towards this approach though — it was helpful to explore.
Hi Aarush9885,
Thank you for reaching out to the Microsoft fabric community forum.
You can fix this issue by unpivoting your columns. If you unpivot Sales, Return and Discount into a single column called Metric in Power Query, and keep the values in another column Metric values, then use Metric in columns and MetricValue in values of the matrix.
With this setup, the tooltip will get both Product and Metric context, so when you hover it will show the correct value for each metric instead of repeating the same number.
I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Community Support Team.Hi Aarush9885,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.Hi Aarush9885,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.
- Natalie_iTalent
Administrator
Hello Aarush9885,
The comment you are responding to has been removed. I hope one of the answers provided help solve your question.
Best,
Natalie H.
Community Manager
