Forum Discussion
Dynamic Slicer
- 1 year ago
Power BI does not have the built-in ability to automatically deselect previous slicer selections as Tableau does, so manual deselection will still be necessary in the second slicer unless you use visuals and dynamic measures to display the output based on user selection.
You can create a mpping table that links the categories with the default item you'd like to select from the second slicer and and create a relationship between the first slicer’s table (Category) and the mapping table (Category).
Then create a measure :
SelectedItem = VAR SelectedCategory = SELECTEDVALUE(CategoryTable[Category]) RETURN CALCULATE( FIRSTNONBLANK(MappingTable[Default Item], 1), MappingTable[Category] = SelectedCategory )While this doesn't "force" the second slicer to automatically select items, it dynamically updates a visual with the first item corresponding to the category selection. Users can then interact with the second slicer as needed for finer control.
Hi jo123456
These capabilities are available with the new and new list slicers
pbix with the example is attached
more information about these slicers in the linked guides :
https://www.youtube.com/watch?v=V8etUojIQmw
https://www.youtube.com/watch?v=mSn08LiATGo
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly