Forum Discussion
Limiting Filter Options
Hi JM_nxgn
Please see the below solution.
1. Create a measure
_filter = INT( NOT ISEMPTY( Owner ) )
2. Use this measure as a filter on both sliners like below.
Second option is to create one dimension table that contains both Breed and Animal and link it to Owner on Breed ID, and this would be the best practice.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi JM_nxgn
Not sure if I understand what you need, but if you have one table with both columns in than the behaviour should be as below.
Please let me know if that is what you expecting.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi I just noticed now what you said is true. I made a table with the two columns and does exactly as what you mentioned.
I don't know why this isn't the case with the table I have created though. I'm using report level filters on the right side bar if that makes any difference?
Hi JM_nxgn
If you filter visual in the Filters Pane then you are filtering only the visuals display, it does not propagate to the model for some reason, however if you apply your filter on this page / all pages levels, then you will get the desired result as below.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.