Your full explanation on my past question in the below link helps me a lot to further understand data blending common filter. Thanks a million.
Based on your explanation there, I have some extra question and want to ask your insight to get more knowledge
In your original question, you mentioned "
Due to the caveats of using blended data for filtering, Parameters are an appealing alternative to Quick Filters. Parameters span data sources, and so are fairly robust for filtering. The typical disadvantages of Parameters apply — no dynamic domain population, no discrete multi-select, etc. — so make sure that your desired user experience is tolerant of these disadvantages before leveraging Parameters."
I have a user case here and want to make sure whether the no dynamic domain population you mention here means the no cascading parameter or it means different thing.
In the attached twbx file , the first dashboard we have here called One parameter control two data source_state. This dashboard use the same parameter State to apply to internal and external data to make the comparison. We populated the state to the details level in the parameter. The detail parameter( such as MD) is applying to both internal and external.
The second dashboard, which called one parameter control two data source_cbsa, did the same thing,populate the CBSA to the same parameter and the detailed cbsa apply to both internal and external data by one parameter.
However, The above two dashboards themselves is great while when
1. we want to combine cbsa and state in the same dashboard
2. use the populated cbsa details or state details to drive both internal data and external.
I got stuck since my parameter only go to first level- combine the cbsa and state and I do not know can not go further to get the level 2 populate the cbsa or state and apply the details to both sheets. What I have now is the dashboard 3, first level parameter CBSA and State flip apply to both internal and external sheet but the second level cbsa, state details need to use separate filters for internal and external sheet.
Is that is any way to create a cascading parameter to populate the State (MD etc) and CBSA into the level 2 parameter and let the level 2 parameter works on both sheet so that details state or CBSA can control both sheets?
Hope that my explanation of the case is not that bad but let me know if there is anything which is unclear
CascadingParameter.twbx 177.2 KB