Forum Discussion
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 graph...
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.