How to use slicer to remove counts of column from chart

[Nudo]

Hey 

Once again having trouble with something, usually I end up figuring a solution myself but I always like to see what people say anyway.

So I have a line chart x axis is year + week, y axis is a count or sum of a bunch of columns of things that were created on that date.

These columns come from multiple different tables and I'm doing a count or a sum on these. So my issue is I can't figure out how to filter by each of these columns. If I put the column in the slicer it has all the values from that column in the slicer, I want to just totatly filter out this whole column no matter what the value.

I want to be able to fully hide a visual from the chart with the slicer. Any idea how I can achieve this? 

[MFelix]

Hi @Nudo ,

To what I understand you have a metric similar to this:

Total value = SUM(Table[Column]) + SUM(Table[Column2]) + SUM(Table1[Column])

And you want to filter out the values from of the columns in order to have your calculation.

Try to add a Table with the name of the columns something similar to:

Table[Column]

Table[Column2]

Table1[Column]

Now redo your metric in the following way:

Total value = 
IF("Table[Column]" in Values(NewSlicerTable[Column]),
SUM(Table[Column])) + 
IF("Table[Column2]" in Values(NewSlicerTable[Column]),
SUM(Table[Column2]) + 
IF("Table1[Column]" in Values(NewSlicerTable[Column]),
SUM(Table1[Column])