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
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
Thanks for the help and ideas themistoklis !