Forum Discussion
Filter Field Parameter by Field Parameter Values without Calculated Groups
Without creating an extra measure, your current hierarchy filter won’t fully work. You’ll be able to filter Fleet Group, but only one of Route Segment or Route Group will work at a time since they come from the same table and only one relationship can be active.
If you want to avoid using a measure, your options are to create separate dimension tables for Route Segment and Route Group, or add a column in your hierarchy table that uniquely identifies each row in the fact table, like an Index or Record ID. That second option can get messy, especially if you have multiple fact tables.
Either way, even with your current hierarchy table, you’ll likely need to deal with a many-to-many relationship.
Try the attached pbix.
Create another field parameter like you normally would. This will be independent from the first parameter but you can use this within the same visual and even if you don't you can stil use it to filter the value of that visual.
Hi danextian ,
This isn't quite what I'm trying to achieve. This only allows me to filter by the list of Fields from the selected Field Parameter. But in my example, I need the user to be able to filter fields from all 3 Fields parameters, even when it's not the one that's been selected.
For example:
- my Field Parameter has 3 options - Fleet Group, Route Group and Route Segment
- Fleet Group will have different aircraft types while Route Group will have different route options, like Asia or America
- If one of my users have Fleet Group selected from the Field Parameter, the axis will show a list of different Aircraft Types
- With this additional filter I want the user to be able to filter by Route Group, say America, and all the Aircraft Types from Fleet Groups will narrow down while the axis remains the same
- Similarly, if someone selects A380 from Fleet Group and America from Route Group, the axis, which is showing the Field Parameter Fleet Group, show filter to A380 while the value in the chart would narrow down to just America
- So I need the axis to work with the Field Parameter and to be able to be filtered by the Hierarchy filter as well as for the value to be influenced by the Hierarchy filter
How can I do this?
Without creating an extra measure, your current hierarchy filter won’t fully work. You’ll be able to filter Fleet Group, but only one of Route Segment or Route Group will work at a time since they come from the same table and only one relationship can be active.
If you want to avoid using a measure, your options are to create separate dimension tables for Route Segment and Route Group, or add a column in your hierarchy table that uniquely identifies each row in the fact table, like an Index or Record ID. That second option can get messy, especially if you have multiple fact tables.
Either way, even with your current hierarchy table, you’ll likely need to deal with a many-to-many relationship.
Try the attached pbix.