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?
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.