Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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 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.
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.
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 ! 😀
Thank you Speedrams, I thought uses aggregate values. thanks. Its worked.
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 !
The problem still. There is no slicers for mode(airmland,see) and Qty, See in phptp what happened.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |