cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gvg
Post Prodigy
Post Prodigy

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
Ashish_Mathur
Super User III
Super User III

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/
v-huizhn-msft
Microsoft
Microsoft

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

@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

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
Super User IV
Super User IV

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


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

@ me in replies or I'll lose your thread!!!

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!




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.

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


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

@ me in replies or I'll lose your thread!!!

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!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors