Make a table ignore a specific filter

[sebastanaka]

Hello, Thanks for helping.

I have three tables in my sheet. The first breaks down the top items in the current week that were not sold, the items are distinguished by an item id. The second goes over the top locations in which the item is not selling, currently it is working correctly where if you click on an item in the first table it will breakdown all the locations in the second table with this product. The third table is meant to go over historical sales on the item, in this case the week prior, however the filter that narrows down the weeks is called "week timing," with 0 being current week and -1 being 1 week past. When I click on the item in the first table it doesnt not populate the third table with the current information becuase of the conflicting week timings.

I need all three tables to be linked with the Item ID but only the first and second table to use the week timing=0 and the third table to use week timing=-1. 

Please help, thanks in advance for your time and consideration.

[PBIViz_2024]

Hi,

You can have the weektiming filters only to the selected visuals using option "Filters on this visual" in the filters pane.

What you need to do is click on the specific visual.in your case lets say 1st Table then in the above filters section,apply weektimings =0 and same for table 2.For table 3,apply weektimings equal=-1.

Thanks

[sebastanaka]

Thanks for your input,

I tried this, and I already have the filter set up this way however it just leaves the 3rd table blank when clicking on a specific item on the 1st table.

[PBIViz_2024 · Accepted solution]

Hi ,

If this is what you have looking for ,You can achive this by creating two measures.

once you click on the item on the first table 2nd table will filter to show the locations of respective items and third table shows the last week qty of the selected item.

Please check the attached PBIX  for more info.Two solutions were given.Hope this works.

Regards,