Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to change tooltip based on hover selection?

I have stacked-bar visual that uses 4 measures in it. When I hover over the individual bar item, it only displays the "first" item for the label. Is there any way I can write a DAX formula to change ...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous see attached, making your data unpivot makes things easy, no need to write multiple measures and you can always filter by any attribute/inventory type etc. Tweak the solution as you see fit.

parry2k's avatar
parry2k
Super User
3 years ago

Anonymous  can you share sample data and the measure you have used for buckets? maybe a simple change in the model can work here without doing any extra work?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi parry2k  - below is a link to some sample data from the model. I highlighted a few rows in the dataset that helps describe the problem, and why I'm using a stacked bar chart with 4 measures.


    Link to sample data: Inventory Volume.xltx

     

    Its possible for a single row to contain both Healthy and Excess inventory, therefore we can't use the Health_Category column. This is why I am using 4 measures in my Y-Axis above. So I want to have a label in the tooltip that cooresponds to the measure I am hovering over. I hope this helps explain the issue in more detail.

    Edit: chrome might have issues with that link to OneDrive, but using MS Edge works fine