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.
Hi,
I have build a report and there are two filters, one is "boardmember" and the second one is
"owner". Now I want when filtered on a boardmember that only the owners with a value will show up.
For example:
Boardmember a = Owner 1, 2, 3
Boardmember b = owner 5, 6, 7
Boardmember c = Owner 8, 9, 10
So if I filter on boardmember a, only owners 1, 2, 3 should show in the filter.
A bit like explained here: https://www.youtube.com/watch?v=o8K4Px_6AYQ
But now I have both fields in the same table so option one isn't available.
And I can't make a certain value like "amount complaints" of claims because it is filtering multiple graphs with different values.
Thanks in advance
Solved! Go to Solution.
@Anonymous So your slicers are coming from the "blocked/shaded" tables?
your tables have many to many relationships which must be avoided. You need to create dimension or "bridge" tables with unique values linked to your fact tables in one to many relationships to use as your slicers
once you have done that, create a measure to filter the slicers based on the selection made in the other. Use:
Filter slicers = COUNTROWS(RELATEDTABLE(Fact Table))
select each slicer visual and add this measure to the filter pane for each slicer and set the value to "Greater or equal to" 1.
Proud to be a Super User!
Paul on Linkedin.
@Anonymous So your slicers are coming from the "blocked/shaded" tables?
your tables have many to many relationships which must be avoided. You need to create dimension or "bridge" tables with unique values linked to your fact tables in one to many relationships to use as your slicers
once you have done that, create a measure to filter the slicers based on the selection made in the other. Use:
Filter slicers = COUNTROWS(RELATEDTABLE(Fact Table))
select each slicer visual and add this measure to the filter pane for each slicer and set the value to "Greater or equal to" 1.
Proud to be a Super User!
Paul on Linkedin.
Thank you!
@Anonymous
Yes please
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
Please show a depiction of the model with the tables you are using as slicers and the fact table
Proud to be a Super User!
Paul on Linkedin.
Sorry for the confusing,
The fields I want to filter on (board member and owner) are both in the same table, that is the fact table. Further I have a table for datefields (which i dont use in these two filters).
Let me know if you still need the model.
Thanks again for your help
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |