Forum Discussion

LucasResendeR10's avatar
LucasResendeR10
Frequent Visitor
2 years ago
Solved

Problem with graph interactions

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
    )
)




7 Replies

    • LucasResendeR10's avatar
      LucasResendeR10
      Frequent Visitor

      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's avatar
        lbendlin
        Super User

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