Tooltips

Hi James,

Thank you for the forum question.

Yes but you will have the create the logic.

I created a matrix and added the Sales Reps first name and the sales. I use the data model from the course.

Then I created a custom tooltip page and wrote the measure below.

Text to display = "this is a text string " & SWITCH(SELECTEDVALUE(Reps[INITIALS],"non"), "HDN", VALUES(Reps[COMMISSION RATE]),"tas",VALUES(Reps[REGION]),"It is not TAS or HDN")

When I added the custom tooltip page to the matrix, the custom tooltip showed the sales reps' commission rate if I hovered over the sales rep with the initials HDN and the the sales rep's region, when I hovered over the sales rep with the initials TAS. When I hovered over the rest of the sales reps, I just got "It is not TAS or HDN".

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector