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
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.
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.
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.
I don't want them to not interact with some visual, I don't want them to interact with some filters.
Source Community: Power BI Spanish | Source Author Name: Guiliam_spa_82
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.
Anyone has an idea please ? 🙂
