Filtered table interactivity

[giorgiokatr]

I have a table which shows segments in rows and some values in columns. It has a visual filter to show only the last date. 

There is also a timeline visual which shows dates and values. When i i click a segment in a row in thr table it filters the timeline with the last date and shows the filtered segments. Is it possible to not filter the dates and only filter the row i click?

[v-juanli-msft · Accepted solution]

Hi @giorgiokatr 

As a workaround, don't add visual level filter to the table visual, create a measure which calculates the corresponding values for the last date.

Then click on the table visual, the timeline visual would only be filtered by "cate" instead of "cate"+"date".

[DATE] is a column created in "Sheet1" with formula:

DATE = [datetime].[Date]

It has a relationship with "DATE" table.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[giorgiokatr]

I have a table that shows segments in rows and some values in columns. You have a visual filter to show only the last date.

There is also a timeline visual that displays dates and values. When I click a segment in a row in the thr table it filters the timeline with the last date and displays the filtered segments. Is it possible not to filter the dates and just filter the row I click?

[Greg_Deckler]

See this thread: https://community.powerbi.com/t5/Desktop/Filtered-table-interactivity/m-p/1064220

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Greg_Deckler]

Maybe using something like ALLEXCEPT but that depends on a huge range of information that is not provided.