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

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors