Problem with graph interactions

[LucasResendeR10]

Hello! I hope you're all doing well. I'm facing an issue where I have a column containing multiple terms, separated by commas. There can be up to five terms in a single cell. My goal is to create a bar graph with the terms displayed on the X-axis and the count of these terms on the Y-axis. I successfully created the graph using DAX. It interacts well with other graphs and filters, but unfortunately, the other visuals don't respond to it.

To create the graph, I used an auxiliary table with the terms and a measure (code below). I need help to ensure that this graph interacts properly with the other visuals. The auxiliary table column is in the x-axis, while the measure is in the y-axis.

Auxiliary table:

Tabela_Termos =

DATATABLE(

    "Termo", STRING,

    {

        {"Apontamento de Inadimplências"},

        {"CADIN"},

        {"PGFN"},

        {"Protesto"},

        {"SPC/Serasa"}

    }

)

Measure: 

Contagem_Termos =

SUMX(

    Tabela_Termos,

    COUNTAX(

        FILTER(

            'Report (3)',

            SEARCH(Tabela_Termos[Termo], 'Report (3)'[Qual o tipo de restrição?], 1, 0) > 0

        ),

        1

    )

)

[lbendlin]

Sounds good. Where are you stuck?

[LucasResendeR10]

Thank you for the response! The new graph isn't interacting with the other visuals on the page, but the other visuals do interact with the new graph when I click on them. I'd like the interaction to be mutual.

[lbendlin]

Can you show your data model?  The join arrows can tell you which interactions will be possible.

[LucasResendeR10]

I don't know what you mean by data model so Let me send you what I'm trying to accomplish. Here is the important part of the the table

Main table. The middle column is the one I want to separate the termsTerms separated in DAXThese are the generated graphs, the one circled in red is the new one, the othe one interacts with it just fine, but it doesn't interact with the others.

[lbendlin]

Ah so this is all in one table?  Any filters you apply to that table will overlay each other.  For interaction/cross highlighting you need separate tables

[LucasResendeR10]

The only separated table is the one created in DAX.

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...