Multiple tooltip pages not working in map visualization

[rgruser]

Hello everyone,

I am a beginner in Power BI and I am having trouble with the following issue. I have 3 different sensors located in 3 different locations. I have created 3 different tooltip pages, each with a line chart visualization for each sensor. The main visualization is a map that shows the location of the 3 sensors. When hovering over each sensor, I would like to see the tooltip page associated with that specific sensor. However, I am currently always seeing the same tooltip visualization regardless of which sensor I hover over. I have tried different configurations, including turning the "keep all" filter on and off and adjusting the tooltips on the tooltip page, but I have not been successful so far.

Please let me know if you need any additional information. I have already checked other threads for a solution, but I have not found one that works for my specific case.

Thank you for your help.

TABLE READINGS

SENSOR	DATE	READING S1P	READING S2E	READING S3C
SENSOR1P	1/24/2022	10.5
SENSOR2E	3/16/2022		12.5
SENSOR3C	4/1/2022			10
SENSOR1P	1/25/2022	12
SENSOR2E	3/17/2022		11
SENSOR3C	3/17/2022			12

TABLE SENSOR_INFO

SENSOR	Lat	Long
SENSOR1P	-75.3526	14.07368
SENSOR2E	-75.4005	16.57032
SENSOR3C	-75.3422	12.0879

[rgruser]

@MFelix thank you very much! That was exaclty what I needed!!

[MFelix]

Hi @rgruser ,

In this case you don't need to show the data has 3 pages. Has a best practice you should unpivot your readings so you get the following table:

Then you must have a relationship between your readings and your sensor table

In the example I have a unpivot table and another that is has you have.

For the tolltip depending on how you are doing you need to do one of two things.

• Unpivot data - Add the date to your axis and the reading to your values
• Readings as you have - date on axis and all 3 other columns on the values

Has you can see the result is always correct (top chart is unpivot bottom one is the data as you have).

See PBIX file attach.

[rgruser]

Thank you very much for your reply @MFelix.

I am afraid, my previous example was oversimplified, I apologize. I need separate tooltip pages for each line chart visualization as each chart is unique, and in addition, I'd rather not bundle all line chart viz in one single tooltip page. One sensor has readings in X, Y, and Z, should I unpivot the data to have a single column for all readings?

https://fromsmash.com/SENSORS-RGR 

As you can see in the attached the pbix file, the map viz does not filter the tooltip pages per type of sensor, it always shows sensor E tooltip.

Thank you very much for your assistance.

[MFelix · Accepted solution]

This is a tricky one since you have to setup the charts individually.

Basically you create two measures for the formatting something similar to:

E-Readings X Tooltip = IF(SELECTEDVALUE(SENSOR[SENSOR]) = "E", READINGS[E-READING X])

E Readings x Tolltip Text = IF( SELECTEDVALUE(SENSOR[SENSOR]) = "E", "Black", "#FFFFFF00")

The first one is for the values and the other one is for condittional formatting the titles

Then you setup a measure for each chart/measure you want to show in this case I created 5 measures one for each chart.

You need to turn off the background, result below and in attach file.

Be aware that for make a better formatting of the charts you need to apply the filter of the sensor, after ending the formatting clear the filter of the sensor.

Check this blog post

https://www.esbrina-ba.com/a-truly-dynamic-tooltip/