Forum Discussion
Multiple tooltip pages not working in map visualization
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
Hi Anonymous ,
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.
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.
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