Ignoring filters in table visual

Question

Hi experts,&nbsp;As I understand, when you click on a row of table visual, that row becomes filter in the page. I wonder is there a way to remove some of those filters. For example, I have a date slicer on my page and a table visual that displays this:&nbsp;Date            Customer     Amount
-------         ---------    -------
1/1/18          Coca-cola    1000
1/2/18          ABB           500
2/2/18          ABB           7003/1/18          Pepsico       200&nbsp;If I click on line 1/2/18&nbsp; ABB ..., for example, all the columns in the table visual become filters for other visuals. If in another visual I want to display amounts from ABB for the whole year month by month, I get sum for January only.&nbsp;How do I get rid of Date filter in table visual while keeping date, set in the slicer, fetching only the Customer name for use in another visual?&nbsp;&nbsp;

greg_deckler · Answer

Then you are looking at something like ALLEXCEPT in a measure where you can specify which context filters to honor and which to ignore.

greg_deckler · Answer

In the Format section of the ribbon, click "Edit Interations".

gvg · Answer

Yes, but there you kill all the filters. I want to be able to get ABB, but not date and other filters from the table visual.

v-huizhn-msft · Answer

Hi&nbsp;gvg,Please create a measure using the formula and use it in another visual.&nbsp;
result =
CALCULATE (
    SUM ( Table1[Amont] ),
    FILTER (
        ALL ( Table1 ),
        Table1[Customer] &lt;&gt; SELECTEDVALUE ( Table1[Customer] )
            &amp;&amp; MONTH ( Table1[Date] ) = MONTH ( SELECTEDVALUE ( Table1[Date] ) )
    )
)

You will get expected result as follows.Best Regards,Angelia

gvg · Answer

v-huizhn-msft&nbsp;Well, this is not exactly what I am looking for. I need to be able to capture selected Customer and chart this:&nbsp;

Forum Discussion

Ignoring filters in table visual

7 Replies

Related content

Need one Visual to ignore a Page Filter

Ignore filter for a measure

Make measure ignore specific filter

Ignore visual level filter from a measure

Ignore filter on visual