Conditional Text in a TT page based on segment hovered in stacked column chart

Hi jjustjjo ,

I’ve found a way to determine the column segment. It’s more complicated than I’d thought, and I hope it works in your report too.

The solution is based on a calculation group:

1. Define a new calculation group named "Column Segments"
2. Name the column of the calculation group something like "Selected Measure"
3. Define a calculation item for every of your measures defining the segments. Every items should look like the following one:
   
   A Name for the Segment = IF(SELECTEDMEASURENAME() = "Chart Dummy",
       [your measure for the segment],
       SELECTEDMEASURE()
   )
   (The IF clause ensures that the only a measure called "Chart Dummy" will be replaced by your segment measures)
4. Define the Chart Dummy measure:
   Chart Dummy = 0
   (The exakt definition is irrelevant, because the measure is replaced by the measures defined in the calculation items)
5. Add Chart Dummy as the only value to the y-axis of your chart
6. Add Column Segments[Selected Measure] as a legend to your chart
7. Now it should be possible to use the following measure to detect the selected segment at your tooltip page
   Tooltip Measure Detector = SELECTEDVALUE('Column Segments'[Selected Measure], "No selection")
8. Here is an impression from my demo:
   

    

Hope that works for you too.