by This is more related to the previous use case, if you come to this article first I suggest to see the previous business use case for better understanding.
Okay, This time we have to deal a dynamic selection in the slicer.
Is it possible?
lets understand the requirement first,
I have a slicer which is append of Exclusions list following Inclusions list. Exclusions list is changing dynamically. I want to select only the exclusions in the slicer even if the exclusions value get added or removed.
Well, this could be look like Power BI application development request. Lets try to achieve as much as possible
as per previous use case, lets create one more custom column in power query and named as we want for both the table.
Add Custom Column in Exclusion Table:
Add Custom Column in Inclusion Table:
Final Append Table Reflects the Type in the table:
Lets use the custom column and the city in the slicer hierarchy for dynamic selections.
When any values will added or removed in the Exclusions table values get automatically updated and we put those values in the granularity hierarchy level. So if we select the to level and keep it stable, the exclusions value automatically checked because of down to the hierarchy.
This is the quick solution I think, feel free comment any other ideas!
