Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Block a filter on some visuals

Hello,

 

I have a dashboard about this and last year problems.

I want to block two visuals so they don't get influenced by the Year. For example if I choose the Year=2021, I don't want these graphs to disappear, I want them to stay the same. They should still be able to be influenced by the week.

I made a specific measure for each graph :

Coste_2022 = CALCULATE(SUM(Tabla_CNQ_NCR[Coste_CNQ_Total]),FILTER(Tabla_CNQ_NCR,Tabla_CNQ_NCR[CNQ_Año]=2022))
Coste_2023 = CALCULATE(SUM(Tabla_CNQ_NCR[Coste_CNQ_Total]),FILTER(Tabla_CNQ_NCR,Tabla_CNQ_NCR[CNQ_Año]=2023))

 

What should I do? Create a new table only for those graphs ?

 

Best regards

 

Need Help

5 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I think what you have to do is go to the "format" tab and click on "edit interactions". Here it allows you to enable or disable the interaction between different visual elements.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Anyone has an idea please ? 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I don't want them to not interact with some visual, I don't want them to interact with some filters.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Ok so here is what I did.
    I create a new table : 

    Coste_2022 = SUMMARIZE(FILTER(Tabla_CNQ_NCR,Tabla_CNQ_NCR[CNQ_Año]=2022),Tabla_CNQ_NCR[TIPOF],"Total",SUM(Tabla_CNQ_NCR[Coste_CNQ_Total]))

    Like this, my visual is not afected by the filter from the main page. If anyone has a better way of doing it, I'm open to suggestions.
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Well, it was not a good solution.

    Because now the visual is not affected by the Year filter, but it's not affected by any filter from the main page and that is the issue.