Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Found it
Works
Many thanks
how to make it bi-directional?
Hi,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |