Forum Discussion
Linking filters
So in the table it seems that for Sales Stage = 'Closed' there are multiple 'Status' values.
You are trying to Set slicer value based on another slicer value... is that correct?
If this is the case I dont think it can be achieved in PowerBI
https://community.powerbi.com/t5/Desktop/Set-slicer-value-based-on-another-slicer/m-p/908632
https://community.powerbi.com/t5/Desktop/Dynamic-Slicer-based-on-Slicer/m-p/429694
Im a bit confused. When you say it doesnt save what do you mean?
Can you also share a file with us?
Also you need to check the data model that you use in PowerBI.
You need to check the relationships between the tables (e.g. one to many etc)
For example, are there cases when you select 'Closed' from one slicer to have multiple values on the other slicer
Sorry ... maybe I am not explaining it correctly.
When I select Closed in the Status slicer I would like PowerBI to automatically select Closed Won in the Status slicer. I tried your instructions but it didn't work - which means I probably did something wrong. Can't send the file as it contains company data.
You should check your model. It seems that for Sales Stage = 'Closed' there are multiple 'Status' values assigned to it.
You need to check the relationships between the tables (e.g. one to many etc)
All data is in one table. No relationships to manage (from what I see).
So in the table it seems that for Sales Stage = 'Closed' there are multiple 'Status' values.
You are trying to Set slicer value based on another slicer value... is that correct?
If this is the case I dont think it can be achieved in PowerBI
https://community.powerbi.com/t5/Desktop/Set-slicer-value-based-on-another-slicer/m-p/908632
https://community.powerbi.com/t5/Desktop/Dynamic-Slicer-based-on-Slicer/m-p/429694