Forum Discussion
Tootip problem
Dear experts, How I deal with tooltip photo attached, I don't want to give all 3 items, I wanted separated. I did custom tooltip, but still gives me all items
Dear experts,
How I deal with tooltipin photo attached, I don't want to give all 3 items, I wanted separated.
I did custom tooltip, but still gives me all items
Hi again majid154a
Sorry for giving you a wrong solution. My bad ! ☹️
The solution will work on a stack graph but not a multiple line graph
It does not work on a multiple line graph because when you hover the mouse you are selecting a single point on the X-axis, but that single X-axis point will have multiple mode values.
You either need to use stack chart graph or use a drillthrough.
However, with a drillthrough the user will have to either right click on the datapoint and select drillthrough.
Or you can prompt the user to select a data point and then click an information button.
Please note you must press Ctrl+click in Power Desk Top to operate button will work with a single clickI have create these examples for you ....
Click here to download an example
Sorry I didnt give the correct answer first time.
Please click thumbs up and accept as solution.
Hi again majid154a
You will kick yourself wel I tell you the answer !
SELECTEDVALUE only returns a value when the context for the column name has been filtered down to one distinct value. So it works for year and mode but not value, because each year and mode has multiple values. Yoy need to aggregate the values.
So the answer is .... (get ready to kick yourself) ....
YourValues = SUM(youtablename[Values])
Please click thumbs up and accept as solution button. Thank you ! 😀
6 Replies
Hi again majid154a
Sorry for giving you a wrong solution. My bad ! ☹️
The solution will work on a stack graph but not a multiple line graph
It does not work on a multiple line graph because when you hover the mouse you are selecting a single point on the X-axis, but that single X-axis point will have multiple mode values.
You either need to use stack chart graph or use a drillthrough.
However, with a drillthrough the user will have to either right click on the datapoint and select drillthrough.
Or you can prompt the user to select a data point and then click an information button.
Please note you must press Ctrl+click in Power Desk Top to operate button will work with a single clickI have create these examples for you ....
Click here to download an example
Sorry I didnt give the correct answer first time.
Please click thumbs up and accept as solution.
Hi again majid154a
You will kick yourself wel I tell you the answer !
SELECTEDVALUE only returns a value when the context for the column name has been filtered down to one distinct value. So it works for year and mode but not value, because each year and mode has multiple values. Yoy need to aggregate the values.
So the answer is .... (get ready to kick yourself) ....
YourValues = SUM(youtablename[Values])
Please click thumbs up and accept as solution button. Thank you ! 😀
Hi majid154a
Create 3 dax measures .....
Transport year =
SELECTEDVALUE(yourtablename[transport year])
Transport name =SELECTEDVALUE(yourtablename[trasport method])
Qty of journeys=
SELECTEDVALUE(yourtablename[transport qty])
Then create a custom tooltip with 3 cards to display the measures.
Click here for video on how to create custom tooltips
When you hover the mouse on a transport method then only those values will be selected and displayed in the custom tooltip
Please click thumbs up and accept as solution button. Thanks !