Tootip problem

[Anonymous]

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

[speedramps · Accepted solution]

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 click

I 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.

[speedramps · Accepted solution]

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 click

I 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.

[Anonymous]

Thanks Speedrams,
It worked in stack in year and mode, but in VALUE is not worked, I dont know what is the problem. I attached photo for dax code. 

Note: the problem of Value is same in drill-through. it gives me blank.
So thanks.

[speedramps · Accepted 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 ! 😀

[Anonymous]

Thank you Speedrams, I thought uses aggregate values. thanks. Its worked.

[speedramps]

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 ! 

[Anonymous]

The problem still. There is no slicers for mode(airmland,see) and Qty, See in phptp what happened.