Forum Discussion
Solved
Limiting Filter Options
Hi I'm busy building reports which have numerous filters on many different columns. Is there a way to limit the number of filter options based on a previous choice of filter. I'll provide an examp...
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.
adding to that what will be the max number of report filters we can use in dashboard?