Forum Discussion
Linked tables with slicer
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
I appreciate if some one can tell me how to make original table filter based on the slicer
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
7 Replies
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/823601Hi,
In the Query Editor, when splitting data by comma, click on Advanced options and select Rows.
I did
This is how it is at the moment
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.
- 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.
