Manual filter for slicer

[Anonymous]

Hey, I would like to have slicers in the following way: 

1st slicer: select company(forced single selection)

2nd slicer: select contract ids (multiple selections possible, but only 1 per year), so my question is: can I create a manual  filter for the id slicer, that if there has already been chosen 1 id for year x, then it is not possible to chose another id of year x

My table contains: company name, contract id, year as columns and some others

Thank you!

[v-lili6-msft]

hi, @Anonymous 

Based on my research, It is not supported to implement your demand in Power BI currently.

As a workaround, you could create a measure that if there are more than one id is selected in one year, the result will not show.

For example:

This is sample data

Then write a measure

for filter = 
CALCULATE(DISTINCTCOUNT('Table'[contract id]),FILTER(ALLSELECTED('Table'),'Table'[year]=SELECTEDVALUE('Table'[year])))

And drag it into visual level filter and set is 1

Result:

and here is sample pbix file, please try it.

Regards,

Lin