Create a general visual title measure for multiple languages

[enzolima]

I'm trying to make the titles of our visuals dynamic. I've got a table TitleVisuals with column 'Language', 'Code', and 'Text'. My measure is:

GeneralVisualTitle = MIN(TitleVisuals[Text])

For each visual, the title is the above measure. In the filter pane, for each visual i select the code that corresponds to that visual. There are multiple languages for each code, so with the selection of one code and one language, a single selection for TitleVisuals[Text] remains.

However, when i select any type of data inside a visual, the titles of all other visuals disappear.

What seems to happen, is that the filter context of the other visual include the [Code] filter from the filter pane, and it creates an impossible filter: it's trying to filter [Code] with 2 different values at the same time. This is the filtering context of one of the visuals where the title disappears:

So here's my issue:

• I'd like to be able to use a single measure for my visual titles
• I'd like to be able to select a language for my visual titles
• I'd like to be able to still use interactions for the content of my visuals.

Is there any way to solve this without having to resort to write a single measure per visual?

I've tried rewriting the measure to exclude filter context using ALL and ALLEXCEPT, but the issue seems to be that there's no way to include the filter pane filter [Code] of the current visual while excluding filtering context for [Code] from other visuals. If the filtering context from other fields needs to be preserved. If I use ALL, the filter pane filter [Code] of the current visual is also ignored.

[enzolima]

---

@enzolima wrote:

I'm trying to make the titles of our visuals dynamic. I've got a table TitleVisuals with column 'Language', 'Code', and 'Text'. My measure is:

GeneralVisualTitle = MIN(TitleVisuals[Text])

For each visual, the title is the above measure. In the filter pane, for each visual i select the code that corresponds to that visual. There are multiple languages for each code, so with the selection of one code and one language, a single selection for TitleVisuals[Text] remains.

However, when i select any type of data inside a visual, the titles of all other visuals disappear.

What seems to happen, is that the filter context of the other visual include the [Code] filter from the filter pane, and it creates an impossible filter: it's trying to filter [Code] with 2 different values at the same time. This is the filtering context of one of the visuals where the title disappears:

So here's my issue:

• I'd like to be able to use a single measure for my visual titles
• I'd like to be able to select a language for my visual titles
• I'd like to be able to still use interactions for the content of my visuals.

Is there any way to solve this without having to resort to write a single measure per visual?

I've tried rewriting the measure to exclude filter context using ALL and ALLEXCEPT, but the issue seems to be that there's no way to include the filter pane filter [Code] of the current visual while excluding filtering context for [Code] from other visuals. If the filtering context from other fields needs to be preserved. If I use ALL, the filter pane filter [Code] of the current visual is also ignored.

---

Hi, thanks for your reply. This did not solve the issue. Using ALLEXCEPT as in your example i can only ignore both the filter pane and the visual interaction. What i need is to ignore the visual interaction, but not the filter pane.

Also, I am not describing 3 issues. I am describing 1 issue, with 3 points of context.

"Third issue: the filter context conflicts with the title measure, causing it to disappear. We need to isolate the filter context of the title from other interactions on the visual content."

This is what i'm trying to achieve. But as of yet, have not succeeded. This is why i am here.

[rajendraongole1]

Hi @enzolima -You can modify your measure as below:

GeneralVisualTitle =
CALCULATE(
MIN(TitleVisuals[Text]),
ALLEXCEPT(TitleVisuals, TitleVisuals[Code], TitleVisuals[Language])
)

When you select data inside a visual, Power BI applies that selection as a filter across all other visuals.
By using ALLEXCEPT(TitleVisuals, TitleVisuals[Code], TitleVisuals[Language]), you ensure that only the relevant Code and Language filters are applied to your title measure, preventing unwanted filters from affecting the title.

for second issue: This can either be done using a slicer or in the filter pane.

Third issue: the filter context conflicts with the title measure, causing it to disappear. We need to isolate the filter context of the title from other interactions on the visual content.

Hope this approach helps in disappearing titles.