Forum Discussion
Resolver IDynamic Filtering
This is hard to solve because the data you need simply isn’t there. The best you can do is anticipate the type based on keywords in the description, but even that won’t always be reliable. DAX and M have limits — without a clear underlying logic to identify each type, there’s only so much they can do.
Super UserYes, you can let users dynamically group Exhibit Types without advance coding or a static lookup.
Solution:
Create a slicer or filter visual using the ExhibitType table, where users select which types belong to each "group".
Create a disconnected “Group Parameter” table with these group names: “Mobile Devices”, “Computer Devices”, “Neither”.
Let users pick types in slicers for each group (using multiple slicers, one for each group).
Use DAX to create a calculated column or measure to check which ExhibitType is selected in which parameter slicer, and then set the group dynamically for the report visuals.
Because this is dynamic, when a new Exhibit Type is added, it automatically appears for selection in the slicers,no need to republish.
This lets users define groups on the fly, keeps report logic flexible, and needs no ongoing maintenance of external files. All group membership is controlled in the report by the end user.
- IntaBruce
This sounds encouraging, but I don't quite follow what you are proposing, could you elaborate a little please?
v-saisrao-msftCommunity Support
