cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

Ignoring filters in table visual

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?  

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: Ignoring filters in table visual

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Post Partisan
Post Partisan

Re: Ignoring filters in table visual

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.

Highlighted
Super User IV
Super User IV

Re: Ignoring filters in table visual

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: Ignoring filters in table visual

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.

1.PNG

Best Regards,
Angelia

Highlighted
Post Partisan
Post Partisan

Re: Ignoring filters in table visual

@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:

 

Untitled.jpg

Highlighted
Microsoft
Microsoft

Re: Ignoring filters in table visual

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

Highlighted
Super User IV
Super User IV

Re: Ignoring filters in table visual

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors