Forum Discussion
Dynamic Measure when hovered over Stacked Bar Graph
Anonymous try this measure
PCT = DIVIDE ( COUNT('Sheet1'[Guest ID] ), CALCULATE ( COUNT ( Sheet1[Guest ID] ), ALLSELECTED ( Sheet1[Pct Activity Category] ) ))I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k I tried the measure and on hovering over the graph I see the value 1.00. I have also provided more information with example in the main post, I hope it helps.
Anonymous make sure change the format of PCT measure to %
parry2k Yes I did and it still gives me the same value(but now in percentage that is 100%) when I hover over the graph. I have attached 2 screenshot with the measure in the link (screen1 and Screen2) for your reference. I hover over 2 categories and seeing the same result(100%).
Anonymous see attached, not sure why it is not working for you.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k Thanks for sharing the Pbx file, that helped to figure out the issue in my report. I got to know the mistake I was doing, to maintain the order of percentage category in the stack graph, I was sorting it by assigning numbers to the percentage category (example Less than 10% = 1, 10% - 25% = 2 so far) and this was creating a problem. Just curious is there a way where I can sort it in the order and also have this tooltip.