Project Insights
Reputation: 108
Smart slicer to filter out already selected value
I am looking for a way to build smart Slicer [Slice_2] that options out already selected option in Slicer [Slicer_1]. For instance if proj_short_name = NBA-UC-02 is selected on Slicer 1, Slicer 2 should display rest all except NBA-UC-02 as shown below.
Excel attached for quick reference: excel
Upvotes: 1
Views: 87
Answers (1)
Project Insights
Reputation: 108
As user @Mik said in a comment:
Hardly believe that this can be possible even in theory. The purpose of a slicer - filtering, so, If you have 2 slicers that contradicts each other nothing will be filtered. It's better to find an other idea for a data manipulation.
Upvotes: 1
Related Questions
- PowerBI DAX Query - undo filter slicer on certain values based on expression
- Dynamic filtering based on selected value in slicer in Power BI
- Make a slicer to filter for multiple columns
- How to use a Power BI slicer to filter two column of a table
- Power bi - Use Slicer selection in filtering data
- filter a column with same value as selected value in slicer
- PowerBI Slicer to Exclude results
- How To Filter Data in Slicer in Power BI
- PowerBI: Slicer to filter a table Only when more than 1 value is selected
- Dynamic Slicer Selection