Ignoring filters in table visual

[gvg]

Hi experts,

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:

Date            Customer     Amount
-------         ---------    -------
1/1/18          Coca-cola    1000
1/2/18          ABB           500
2/2/18          ABB           700
3/1/18          Pepsico       200

If I click on line 1/2/18  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.

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?  

[Ashish_Mathur]

Hi,

I think your best bet would be to create a Customer slicer.

[v-huizhn-msft]

Hi @gvg,

Please create a measure using the formula and use it in another visual. 

result =
CALCULATE (
    SUM ( Table1[Amont] ),
    FILTER (
        ALL ( Table1 ),
        Table1[Customer] <> SELECTEDVALUE ( Table1[Customer] )
            && MONTH ( Table1[Date] ) = MONTH ( SELECTEDVALUE ( Table1[Date] ) )
    )
)

You will get expected result as follows.



Best Regards,
Angelia

[gvg]

@v-huizhn-msft

Well, this is not exactly what I am looking for. I need to be able to capture selected Customer and chart this:

[v-huizhn-msft]

Hi @gvg,

We can get "ABB" value by creating a measure, but we can not add measure as x-axis, so we can not achieve your requirement. Please see this idea and comment on it.

Best Regards,
Angelia

[Greg_Deckler]

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

[gvg]

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.

[Greg_Deckler]

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