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.
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.Hi Aarush9885,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Community Support Team.