Tootip problem

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.

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 ! 😀