Linked tables with slicer

[AkrMus]

I have 1 table 

that has these data

ID	Code	Value	Group
1	KJ13	571	Finance,HR
2	KJ82	415	Operation,Finance
3	TF72	454	HR,Operation,Finance
4	KJ58	362	Operation
5	ND77	607	HR,Finance
6	KJ83	350	Operation,HR
7	TF96	531	Finance
8	YT39	840	HR,Finance
9	SS34	976	Finance,HR
10	ND26	155	Operation,Finance

I am filtering by Group through slicer

due to business requirements , slicer has to be in a seperate page

to have slicer for groups

I created a copy of the original table and split it by comma

both the copy and the original one are linked by the ID

my problem is that when I filter by group the origonal table does not filter

I have attached pbix file to make it clearer

https://we.tl/t-FaRljwOeYv

I appreciate if some one can tell me how to make original table filter based on the slicer

[Anonymous]

I have a related question about using slicer to filter data in tables with no established relationship. Say I have a list of dates, EOM (End of Month). It goes like this: EOM 1/31/2000 2/28/2000 ... 1/31/2020 I put this in a slicer. Somehow I still get a continuous date displayed as I slide the slicer left or right. However, if I display the end data points of the slicer I do get an EOM such as 9/30/2019 (but the last date could be 10/19/2019 displayed as the right-most date in the slicer). Here's the question. If I have a table with Period (YYYYQ) how do I filter this using a slicer? YYYY is Year & Q is Quarter. This table looks something like this: Ticker, Period, Value Ticker1, 20193, 3.45 Ticker2, 20193, 50.20 ... TickerN, 20193, 17.50 Ticker1, 20194, 4.51 Ticker3, 20194, 62.30 ... TickerZ, 20194, 100.23 ... If I don't have Period, but Date. Then I could use a measure such as this: SelectedDate = Calculate(max(EOM[EOM]), AllSelected(EOM[EOM])) Say, I wanted to sum up all the value based on the selected ending EOM. Say, it's 9/30/2019, not 1/31/2020. My other measure would be this: ValueSelected = Calculate(sum(table[Value]), Filter(table, table[Date]=table[SelectedDate])) That is, if I have Date rather than Period. How would I do this if I have Period as above? Frankly, I don't even know why SelectedDate = Calculate(max(EOM[EOM]), AllSelected(EOM[EOM])) give the correct result when SelectedQtr = Calculate(max(EOM[EOM].[Quarter]), AllSelected(EOM[EOM])) gives 4 & SelectedYear = Calculate(max(EOM[EOM].[Year]), AllSelected(EOM[EOM])) give 2020 It seems the last 2 max assess the entire EOM table rather than the selected band. I think SelectedQtr give 4 because other years has 1,2,3,4 & 4 is the max. There's no way I could structure the quarter to be the latest selected quarter from the latest year.

[amitchandak · Accepted solution]

Can you make the relation bi-directional and try. As the new table is a child(1-many) it will not filter the original table.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[AkrMus]

Found it

Works 

Many thanks

[AkrMus]

how to make it bi-directional?

[Ashish_Mathur]

Hi,

In the Query Editor, when splitting data by comma, click on Advanced options and select Rows.

[AkrMus]

I did

This is how it is at the moment

[Ashish_Mathur]

The original Table will not be filtered when you select a Group in the slicer.  For all practical purposes, the original Table now becomes the one in which the Group column has one value per cell.