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.
How come the List of Descriptions filter only works on the readin filter if I include a variable from the readin table? How do I configure the visual to filter down everything on the page listing only fields from List of Descriptions?
In readintable,
- concatenated 2 fields to create field UniqueKey.
- readintable[CSI Description] contains a comma delimited list of strings.
In Individual Descriptions
- created by reference from readintable.
- also concatenates the same 2 fields to create a UniqueKey.
- readintable[description] is exploded by it's comma delimiter into multiple rows to create individual rows in Descriptions[Descriptions]
From the screenshot below, UniqueKey is the relationship between the 2 tables
Thanks in advance
Solved! Go to Solution.
Hi, @jch
In a one-to-many relationship, you can only filter the relationship by table like table2, but not vice versa.
So you need to put the readintable field in the slicer, whether it is BBS or description.
You also don't need to put two fields from different tables in the slicer, it will cause problems. If you want to filter the readintable data, just use its field directly.
Hope you can understand what I said, If it doesn't solve your problem, Please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jch
You seem to be using the uniquekey in the bbs table, which is only related to readintable. You need to change the field on the slicer to the uniquekey in the readintable table.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-janeyg-msft I appreciate your feedback. I might be misinterpreting your solution.
Below is a screenshot describing the results of adding the UniqueKey from the readin table to the Individual BBs filters:
1. The idea is to filter the visual for readin[List of BBs] by the visual for Individual BBs[List of BBs]
2. I added UniqueKey to the Individual BBs filter and it still does not filter the readin visual
Much appreciated!
Hi, @jch
In a one-to-many relationship, you can only filter the relationship by table like table2, but not vice versa.
So you need to put the readintable field in the slicer, whether it is BBS or description.
You also don't need to put two fields from different tables in the slicer, it will cause problems. If you want to filter the readintable data, just use its field directly.
Hope you can understand what I said, If it doesn't solve your problem, Please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |