Eliminating "first/external" filter in tooltip page

Hi all,

See the attached sample pbix where we implement the following:

1. We want to implement translation of titles for differnet viuslas in a report. We have a table TitlesT that provides, for a title in English, its translation into different languages:

Language	EnglishTitle	TranslatedTitle
en-US	TitleMain	TitleMain
fr-FR	TitleMain	TitleMain_FR
de-DE	TitleMain	TitleMain_DE
en-US	TitleTTip	TitleTTip
fr-FR	TitleTTip	TitleTTip_FR
de-DE	TitleTTip	TitleTTip_DE

 

We have a simple measure for translating the title of visuals:

 

TitleMeasure = 
SELECTEDVALUE(TitlesT[TranslatedTitle])

 

 

We set, through a filter visual, TitlesT[EnglishTitle] to the English title that we want for the visual and [TitleMeasure] will return the translated title. We use [TitleMeasure] as fx in the title of the visual.

The language is selected through a filter on all pages in the filters pane and the titles of the visuals will be translated accordingly.

 

2. The report has a Main page with a simple chart MainChart.  We apply a visual filter to the chart with value TitlesT[EnglishTitle] = "TitleMain" to set the correct title to it.

 

3. We create a page tooltip called TTip. It has a simple chart (TTipChart). TTip is the tooltip for MainChart. We apply a visual filter to the TTipchart with value TitlesT[EnglishTitle] = "TitleTTip" to set the correct title

 

The expected behavior is that MainChart shows TitleMain (or any of its translations) as title and TTipChart shows TitleTTip (or any of its translations) as title. If you look at the pages in the attached pbix separately, that is what happens:

 

The problem is that when we hover above MainChart, the tooltip is shown without title:

 

This is because TitlesT[EnglishTitle] has both "TitleMain" and "TitleTTip" as values in the filter context (respectively set in the visual filters of MainChart and TTipChart). Thus the SELECTEDVALUE() in TitleMeasure returns blank and no title is shown in TTipChart.

 

Within the tooltip page,  we want to eliminate TitleMain and keep only TitleTTip from the filter context so that the TTipChart shows the correct title. 
How can we do that?

In essence, we want to keep the "closest" filter, applied to TitlesT[EnglishTitle] in the TTip page, and discard the "external" one coming from the Main page.

 

Thanks everyone

 

OwenAuger TomMartens MFelix  AlexisOlson edhans jdbuchanan71